Creating a Lookup Field that Displays Data based on Other Field's Selection

[spora]

Good morning all,

I have an assignment to create a table such that, for example, if a country is selected in "COUNTRY" field, the "STATES" field will display a list of all states for that country selected in "COUNTRY" field.

If another country is selected, the "STATES" field will list just the states in the selected country from which users can then select.

Any assistance, please.

 

[John Big Booty]

Welcome to the forum.

You might get some inspiration from the sample here

 

[spora]

Thanks that is exactly what I wanted. Unfortunately, I see you have to write a program to achieve this, which is not my area.

Any other non-programming way of doing it.

 

[John Big Booty]

Have a look at the article here.

 

[spora]

Thank you, so much. I am so greatful.

 

[samjh]

Hi, I'm quite new to this but this is exactly what I want to put into my databse, however I just need a little guidance please.

I have a table which will have client commtiments in it. The user will select a cost centre (which is currently a lookup from another table) they then select an account code (which is currently a lookup from another table) this will be entered through a form. Within my relationships my Cost Centre and Subjctive are joined as a many to many relationship.

What I want to do is limit the account codes based on what the user selected from the cost centre.

My questions are these:
How do these tables connect within the relationships window if at all.
Do I need to change the layout of the existing commitment table, to remove the lookups and have it just text, and put a combo box in the form to do the lookup?

I may have more questions depending on the answer to these! thank you for your help.

I have tried this, and have followed the simplist cascading list instrcution, but nothing appears on my second combo box. please help.