I am quite new to the world of ACCESS. I am preparing a database of
Suppliers. I have two tables INFO & LOCATION. The info form includes a number
of fields with respect to the basic information of the supplier and the
location form consists records of Area, City & Country. Example of such
records are:

Area    City    Country
Area1    City1    Country1
Area2    City1    Country1
Area3    City2    Country1
Area4    City2    Country1
Area5    City3    Country2
Area6    City3    Country2
Area7    City4    Country2
Area8    City4    Country2

I want the main data entry form to be showing the location's three fields
like:

Upon selection of the Country field a list should open showing the UNIQUE
names from the location table i.e.:

Country1
Country2

Then upon selecting the City area UNIQUE names of cities should be showing
in a list i.e. if Country1 is selected:

City1
City2

Finally the Area field shows the names falling in such a City i.e. if City1
is selected:

Area1
Area2

The lists should also be showing the options in an alphabetically ascending
form no matter how the areas have been entered in the table.

How can I devise such combo boxes.

Thanx in advance