Filter by Form & linked combos

T

TMM

Hi there:

I have the following question:
I have a country table (countryid, country_name) with values as:
0, "Mexico"
1, "USA"
2, "Canada"
for example.

I have a city table (cityid, countryid, city_name) too, with values as:
0, 0, "Guadalajara, MX"
1, 0, "Zacatecas, MX"
2, 1, "L.A. US"
3, 1, "Denver, US"
4, 2, "Toronto, CA"
4, 2, "Ottawa, CA"

Then I linked this tables using the Relationships feature of access 2003.

I created a form with two fields, country_name and city_name.

The problem is: when I execute the form and enter to the "Filter by Form"
view I select "USA" in the country field... I expect to see only the cities
that belong to America in the city field but ALL the cities in the city table
are shown.

How can I filter the city field to show only the values releated with the
country field in the "Filter by Form" view?

Any ideas? What am I doing wrong?

Thnk for your help

TMM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top