Zip it up...

[Leather Knight]

Hey all,

I have a zipcode database with city and state. It is a basic one. I also have another database, Contacts. I want Contacts to draw from the zipcode database the city and state when the zipcode is inserted.

I looked around, but do not seem to find this.

Thanks,

[Breezer]

Relate the two files (using the zipcode table) using the zipcode as the key. After you have created the relationship between the two, make the city and state a looked up value from your zipcode file (using the zipcode table).

Make sure the zipcode field is defined as TEXT.

[Leather Knight]

Thanks Breezer, I have done it before, but forgot to make sure the zipcode was related in both. Thanks.

[T-Square]

Of course, zip codes do not always correlate one-to-one with municipal jurisdictions, so you best be ready to cope with one zip code having 2 cities... Ideally, you'd use a non-significant serial number ID in the zip table as the join field. That will allow you to have two city entries for a single zip code when necessary.

David

[mkruter]

T-Square,

Then what? Do you still type in the zip in the zip field? Or do you have to choose the serial number and if so what will display in the zip field? Plus why cant you have two records in the zip table that use the same zip but list a different city? Can you use a Zip filter table to allow choosing the cities related to that one zip?

[Leather Knight]

Forgive me, even the post office makes mistakes. As for the field, there are 90000 others that are just fine compared to the 10. That is better odds than I would expect...It works and there is no fix to it, so we just accept the "oops" of the post office...