W
Willam Lamberto
I'm not sure if this is even possible in Access, but what I'm
trying to do is the following. I have a table set up where a
user can enter CityName, State, and County. State and County
information is being stored in two other seperate tables (lookup
tables...). Anyway, what I would like the user to be able to do
is enter the city Name, then select the State, and then have a
choice of counties restricted by the state. In other words, the
County table will have the various county names and their
corresponding states, and I want the city info table to
reference the information in that table and present ONLY the
counties that correspond to the current state. I hope I'm being
clear enough. Is it possible to have a query use data in the
current record as criteria for its search? How do I do this?
Thanks in advance for any help...
-Willam
trying to do is the following. I have a table set up where a
user can enter CityName, State, and County. State and County
information is being stored in two other seperate tables (lookup
tables...). Anyway, what I would like the user to be able to do
is enter the city Name, then select the State, and then have a
choice of counties restricted by the state. In other words, the
County table will have the various county names and their
corresponding states, and I want the city info table to
reference the information in that table and present ONLY the
counties that correspond to the current state. I hope I'm being
clear enough. Is it possible to have a query use data in the
current record as criteria for its search? How do I do this?
Thanks in advance for any help...
-Willam