How do I define a field so that it is automatically filled in with a value from a another table?

[mgrube]

I would like to define a field (mailingaddresscounty) as type lookup using a field (county) from another table (Zip). But instead of the user selecting from a long list, I would like the selection to be automatically made based on the value of another field (mailingaddresszipcode). The two tables are Organizations and Zips. The user enters the 9 digit zipcode in the organization table (mailingaddresszipcode). I would like the county field in the organization table (mailingaddresscounty) to draw from (link to?) the corresponding 5 digit zipcode in the Zip table (zip) and return the correct county for that zipcode. I am attaching an example file.


thanks for your help!

[June7]

Advise not to use lookup fields (I NEVER do) especially if they have alias http://access.mvps.org/access/lookupfields.htm. Build combobox on form.

You already have field for zip in People and Organizations, there is no need for the county to also be saved. That is duplication of data.