FIELD BASED FILTERATIONS

[FARAZ QURESHI]

Hi,

Quite new to Access and not well versed! Sure would oblige your help in this
regard. One of my tables is based on locations with two fields of City and
Country.

Now, in the other table of Customer's location I want to select the Country
first and upon selecting the same the City Field's drop-down box to be
showing only the relevant cities of the said country.

How to:
1. Show the Country Names once only?
2. Show only the relevant Cities?

 

[Wayne-I-M]

Hi

Base your 1st combo on a totals query

SELECT TableName.Country
FROM TableName
GROUP BY TableName.Country;

Then 2nd combo is a casscading combo from this - serch this forum for
Casscading Combo - there are lots of codes for this here

Good luck