Microsoft access field thats dependent on value of other field

[DonMcCoy]

I have 3 table
1- African Countries
2- European Countries
3- Middle East Countries

and then I have a primary records table that contains 2 lookup fields ,the first one is Continent Field and The Other is nationality.

the continent field contains Africa, Europe and middle east.

I just want the nationality field to be updated when choosing in continent field.

like when I choose Europe in continent field I got a the European countries which I had them in the table that I mentioned. and so on for other continents.

I want to do it in a table not form.

how could I do this ?

Thanks

[hvsummer]

actually, Table can't update itself.
you have to do this in query.

[NeoPa]

Sorry to reset the Best Answer. It wasn't wrong, it was simply not an answer to the question posed.

@Don.
From what you've posted I can say that you're heading for trouble unless you give your database design the respect it deserves. If that sounds cryptic then let me explain. Storing different countries in different tables is a very basic design flaw that will surely lead you into trouble. There is no doubt about that. It's a problem waiting to show itself. To help avoid such mistakes here's a very helpful link (Database Normalisation and Table Structures). Please understand that database design and table structure is the most basic and fundamental part of a database. That is why it is so critically important. Skim over it at your peril.

When you have a proper design set up then the ideas found at Cascaded Form Filtering should help you to accomplish what it seems you're after.

NB. HVSummer is absolutely right about such updates not being appropriate to do from the table interface. I understand you may be nervous about setting up a form but it's the only practical way to go about this.