Hi gurus,

I have two fields in the main record table with values lookup from two other tables. These two table has 1-many mapping (like country - States). Can I make change within the record table. When I change the value in country field for a record, the States field will only show the states of that country?

Now I have lookup query for these fields from country and states seperately, so no matter what I change in the country field, the states field show all states for all countries.

Thanks for your advice!

Search here for cascading combo boxes.

If this is done from a form, pbaldy is correct.

If this is a lookup-type field in a raw table, you cannot do what you want that I know of

Thanks all for your response. Looks like the field can not be updated within a table though feels like possible. I have tried to all sorts of query in the lookup setting of the field (from table design view) and can not get it work...

Use forms and stay away from lookup fields in your tables - they will only cause you grief later.