Auto complete

[technide]

I am new to Access, I know I couold do this easily in other DBs using a dependant relationship... but I can't get a handle on it here.

I have Client, a State and Coutry tables. What I want to do is assign a Country to a State (in the State table?) and then when I choose a State in the Client table, the Coutry field is completed automatically.

Any ideas?

 

[zestygirl]

Create your country and state table separately. Then, add a state field to your main table. Then, create a relationship between your state field in your main table, and your state field in your country table. Then, when you create a query, form, or report, include the associated country field - it will be "filled in" as the value has already been assigned.....