City/County table

[Leon]

I would like to be able to enter the city name in one field and have the
county name automatically entered in the next field.
How do I do this?

 

[Larry Linson]

I would like to be able to enter the city name
in one field and have the county name automat-
ically entered in the next field.
How do I do this?

My question is: what are you trying to accomplish? Do you really mean that
you want to have the County automatically entered on a Form when the City is
entered? If so, that would be Controls not Fields.

If you do mean Fields in a Table, then it is inadvisable to store something
that can be re-created when you need to use it -- for example, in a Form or
in a Report. Storing redundant data, sooner or later, will cause you
problems (most likely sooner).

Larry Linson
Microsoft Access MVP

 

[Leon]

My question is: what are you trying to accomplish? Do you really mean that
you want to have the County automatically entered on a Form when the City
is entered? If so, that would be Controls not Fields.

If you do mean Fields in a Table, then it is inadvisable to store
something that can be re-created when you need to use it -- for example,
in a Form or in a Report. Storing redundant data, sooner or later, will
cause you problems (most likely sooner).

Larry Linson
Microsoft Access MVP

 

[Guest]

Unless the area covered by the database is rather small, you'd have to enter
the both the City and State first. For example, every state has a Springfield.

Then there are cities that are not in any county. St. Louis and I believe
Baltimore are examples.