mercystone
Member
- Local time
- Today, 15:53
- Joined
- Sep 20, 2021
- Messages
- 108
I have two tables.
1. Table for countries
2. Table for cities
Out of this the main form is from table for countries and subform for table for cities.
In the table for countries, the counties have been entered
1. USA
2. CANADA
3. ENGLAND.
In the table for cities the user of database enters the cities manually.
Question- How will I create a filter such that the user will filter let's say USA and the city the user has entered manually. For example
USA- the user of database might have typed Washington.
Please assist me.
1. Table for countries
2. Table for cities
Out of this the main form is from table for countries and subform for table for cities.
In the table for countries, the counties have been entered
1. USA
2. CANADA
3. ENGLAND.
In the table for cities the user of database enters the cities manually.
Question- How will I create a filter such that the user will filter let's say USA and the city the user has entered manually. For example
USA- the user of database might have typed Washington.
Please assist me.