FIELD BASED FILTERATIONS

F

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?
 
W

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
 

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

Similar Threads


Top