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

T

tomrosson

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?
 
N

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
 
F

Frank Stone

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