M
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!
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!