Data from Another Table

  • Thread starter Thread starter JoeCL
  • Start date Start date
J

JoeCL

I have 2 tables, one is a employee table with addresses
and the other is the Postal table which contains city,
state zip code fields. My problem is my in employee form I
wanted an autofill on the fields city and state when I
enter a zip code on the zip field. How can I do this?
Thank you.
 
I have 2 tables, one is a employee table with addresses
and the other is the Postal table which contains city,
state zip code fields. My problem is my in employee form I
wanted an autofill on the fields city and state when I
enter a zip code on the zip field. How can I do this?
Thank you.
Click to expand...

Well... DON'T.

Storing data redundantly when you can look it up using a Query is
neither necessary nor wise. If you have a City table in the Postal
table, and another City table in the Employee table, there'd be
nothing to prevent having Tuscaloosa in one table and Biloxi in the
other!

Just store the Zip in the employee table, and join the two tables on
zip; pull up the city and state from the Postal table.
 
Back
Top