Zip Code Lookup Question

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have (2) tables in my db, one is named ZipCode and it has ZipID as
autonumber; Zip Codes as Text; City as Text
This table contains all the zipcodes for the cities in the us.
The other is named States and it has only StateID as a text field,it has all
states in it already.
What I need is a way to link these tables somehow so I can use the state
along with the city and zip code for my lookup on my customers form.
Right now I can use the zip code to lookup the and fill in the city, but no
the state.
What fields can I add to make these (2) tables work together?
 
Dave said:
I have (2) tables in my db, one is named ZipCode and it has ZipID as
autonumber; Zip Codes as Text; City as Text
This table contains all the zipcodes for the cities in the us.
The other is named States and it has only StateID as a text field,it
has all states in it already.
What I need is a way to link these tables somehow so I can use the
state along with the city and zip code for my lookup on my customers
form.
Right now I can use the zip code to lookup the and fill in the city,
but no the state.
What fields can I add to make these (2) tables work together?
Click to expand...

Add the state names to the ZIP table. I've never seen a table without city
and state.

I have a table at http://www.mikepainter.com/ZIP_Codes/zip_codes.php with
some 45k worth that can be downloaded.
 
Back
Top