Forum Discussion

JessicaAdkins's avatar
JessicaAdkins
Qrew Cadet
8 years ago

How to auto-fill a county field based on zip code?

I am having an issue with the address field, it pulls all information except for county. Does anyone have a formula or know of a solution to have a field auto-filled once the zip code has been entered...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
I suggest googling until you can find a free down load of an Excel file with all the US Zip codes.

Then create a new Table called Counties by Zip Codes, where the Key field is set to Zip Code.

Then build a relationship to the Address field based on the Zip code there.  You may find it easier to create a Zip Code mirror field with the formula and use that to make the relationship.

[Address: Postal Code]

Then, of course lookup the County.
SarahClark's avatar
SarahClark
Qrew Cadet
7 years ago
Hi again!
I came across this question because I am trying to do the same thing.
I have a table of zip codes and counties (fortunately I only need Massachusetts).
I set the zip code as the key field.
I created a relationship between this table and the Contacts table (where the address is with the zip code I want to match up).

Now I'm stuck. How do I tell it to match up the zip code in the address field with the zip code in the related counties table?