I've setup a table with a complete zip code listing of all US zip codes and their corresponding states and city names. I've added a combo box to a form that looks up these values and allows the user to find the correct city OR zip code and make that selection. What I'd like it to do is give me the option to store field in the zip code table into the corresponding fields of another table i.e. ZipCode to ContactZip, City to ContactCity, etc.
I have considered using a relationship to just store the ZipCodeID into the Contacts table but the US Postal Service updates their zip code database frequently and I don't want any possibility of a zip code ID changing what zip code it is attached to and ruining my data. Any thoughts on how to accomplish this?