If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Zip Code Lookup Question
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? |
#2
|
|||
|
|||
Dave Elliott wrote:
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? 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Spell Check Correction Case Correction Code Question | Dave Elliott | Using Forms | 1 | September 17th, 2004 04:40 PM |
Email Command Button Code Question | Chris from Waterworks | General Discussion | 0 | July 27th, 2004 06:20 PM |
Lookup Question | JackTaylor | Worksheet Functions | 4 | June 2nd, 2004 09:36 AM |