Lookup

[Menelaos]

In a table (named "General Table") I have a column named "Country" and a
column named "City". The values that these 2 tables get (Lookup function) are
stored in one other table. So each city belongs to one country. In the
"General Table" I have a Drop down list in each column to select from.

So here's the question: How can I restrict the second column ("city") to
show values according to the selection I made to the "Country" column?
For example, if I select "England" as a country from the "Country" column, I
want the drop down list of the City" column to display the cities of England
only (not all the world's cities).

Thanks in advance!

 

[Ken Snell \(MVP\)]

Do not do data entry directly in the table. Use a form for data entry.

Also, use of "lookup fields" in a table are not recommended (yes, I know
that Microsoft makes it easy to do); see
http://www.mvps.org/access/lookupfields.htm

On a form, you can use "cascading" comboboxes to do what you seek. See
http://www.mvps.org/access/forms/frm0028.htm

 

[Menelaos]

Thanks very much, that was very helpful!

Do not do data entry directly in the table. Use a form for data entry.

Also, use of "lookup fields" in a table are not recommended (yes, I know
that Microsoft makes it easy to do); see
http://www.mvps.org/access/lookupfields.htm

On a form, you can use "cascading" comboboxes to do what you seek. See
http://www.mvps.org/access/forms/frm0028.htm

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/