How can I type in a zip code and the city will automatically be f.

[Guest]

I have a table that has the zip codes of our community with the corresponding
name of city.

In another table, I would like to simply imput the zip code and would like
the city to show up in its proper field.

How can I do this?

 

[Nikos Yannacopoulos]

You SHOULD NOT do that! Storing the city name in the zip codes table is
all you need, storing it repeatedly defies the whole idea of realtional
dtatabases. Just retrieve it form the zip codes table using the zip code
as key whenever you need it (in forms, reports etc.) and remove the city
name field from all other tables.

HTH,
Nikos

 

[Arvin Meyer]

Are you sure that the zip code is exclusive to a single city in every case?
The zip code I live in crosses city boundaries and exists for 2 different
cities. The last state I lived in did the same.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Frank Stone]

hi. you already have the zips with city in one table. why
do you need them in another table?
Frank

 

[Joseph Meehan]

I have a table that has the zip codes of our community with the
corresponding name of city.

In another table, I would like to simply imput the zip code and would
like the city to show up in its proper field.

How can I do this?

As noted you normally should not store the city in other than the zip
table.

As also noted, you may not want to rely on zip to provide the city. In
fact I have seen zip cross state borders. Most a will not give you any
problems, but there will be some that will. Of course this could be a good
reason to store the city and state in the primary address table.