Using Zipcodes to auto-complete the city field

[fishbone]

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

[fishbone]

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

[fishbone]

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

[laker_42]

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

[laker_42]

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

[laker_42]

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

[fishbone]

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

[fishbone]

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

[fishbone]

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