Hello, I know this must have been posted a thousand times.

just point me to the right answer please,

Imagine the case, you have a contact database with 2 tables, contacts and locations.

im entering data, i get to country , i choose my country with a pop-up list and then I want the Province to be only the provinces of the previous selected country. I've already set up the locations table with its fields. But I dont know the calculation needed to filter down the results. At this point, I have to remember that the selected province really belongs to the country when I enter data.

Any help would be appreciated.

thanks a lot,

Dan

Create a value list based on a field, then select the field to be based on the relationship.

But that only applies to 1 pop-up list, or am I missing something ?

The 2nd pop-up list should display only the relevant records from the 1st pop-up list. We are saying that both items in both pop-up lists are fields of a table and that I created 2 valuelists that take elements of the fields. Its just the calculation between the 2 because the relationships are made.

Dan

You are missing something...

First you need a table that links contry to province: I'd make a Country table, and a related Province table, relate the two and start entering in data.

Create a Country value list, base it on the Country field in the Country table. This will list all the countries available.

In your main database you need a country field: a relationship links this field to the Province table. Base the Province value list on this relationship.

Ok thanks, I see your point now. Lets see how I get around it.

Thanks a lot.

Dan