how do I set up an autofill in County based on Town field

[Guest]

If I import data into access with the town field already populated, is there
a way that it will automatically fill the county field?

 

[Brendan Reynolds]

Nothing built in, no. It would be possible to create an Access application
that, when a user entered the name of a town, could present the user with a
list of counties that contained towns by that name. I don't know how
widespread this is in other parts of the world, but here in Ireland it is
quite common to have towns with the same name in different counties. For
example, there is a Ballina in Co. Mayo, and a Ballina in Co. Tipperary. So
even with the data available and the application developed, it would still
not be possible to fully automate the process. When a user entered
'Ballina', the application would have to prompt the user to choose Mayo or
Tipperary.

 

[Ron2006]

To get anything more specific than Brendan's reply, we will need more
specifics.

 

[MBSNewbie]

Do you have a list of Towns and Counties? If so, you could have a table with
that list and when a town was typed, the lookup would go to that table and
create a dropdown list based on the town.