Noob here, Maybe someone can help. First off, let me mention that companies try to sell zip code lists when you can just download one from census.gov.

Anyway, i have fields in my database that have city, st, zip....I have a seperate database file of zipcodes that have fields for zip and city along with a lot of other garbage (longitude, etc...no need 4 that).

How do i configure my database to call on the zipcode database file so that when i enter a zipcode in my database that it autocompletes my city field automatically?

Thanks

Noob here, Maybe someone can help. First off, let me mention that companies try to sell zip code lists when you can just download one from census.gov.

Anyway, i have fields in my database that have city, st, zip....I have a seperate database file of zipcodes that have fields for zip and city along with a lot of other garbage (longitude, etc...no need 4 that).

How do i configure my database to call on the zipcode database file so that when i enter a zipcode in my database that it autocompletes my city field automatically?

Thanks

Noob here, Maybe someone can help. First off, let me mention that companies try to sell zip code lists when you can just download one from census.gov.

Anyway, i have fields in my database that have city, st, zip....I have a seperate database file of zipcodes that have fields for zip and city along with a lot of other garbage (longitude, etc...no need 4 that).

How do i configure my database to call on the zipcode database file so that when i enter a zipcode in my database that it autocompletes my city field automatically?

Thanks

Make a relationship between your address table & your zipcode table based on zipcode. Have your city & state fields be auto-enter look up fields based on the zipcode relationship. Now when you enter in a zipcode, the city & state will be populated. This is how we are doing it.

HTH,

John

Make a relationship between your address table & your zipcode table based on zipcode. Have your city & state fields be auto-enter look up fields based on the zipcode relationship. Now when you enter in a zipcode, the city & state will be populated. This is how we are doing it.

HTH,

John

Make a relationship between your address table & your zipcode table based on zipcode. Have your city & state fields be auto-enter look up fields based on the zipcode relationship. Now when you enter in a zipcode, the city & state will be populated. This is how we are doing it.

HTH,

John

Thanx so much, i linked up the wrong field at first, but then quickly realized the problem......all works well now. Thank you!!!

Thanx so much, i linked up the wrong field at first, but then quickly realized the problem......all works well now. Thank you!!!

Thanx so much, i linked up the wrong field at first, but then quickly realized the problem......all works well now. Thank you!!!