Query for zipcode table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I built a database where the user wants to be able to type in the zipcode and
it will fill in the rest of the information. I know that I have to have a
look-up table. My question is how do you call the look-up table? Do you do
this by a query or by code? Any help would be great. Thanks
 
I'm trying to make sure I understand your problem...from what you describe,
it sounds like the user is typing a little of the Zipcode in, and they want
the zip to plug in automatically after they type a few letters. If this is
the case, you can do it this way:

1. Build a table, ZIPCODE, of all zips you would use.
2. In the MASTER table of names/addresses, you will need to add a Lookup
Column to pickup the ZIPCODE
3. Choose Insert...Lookup Column from the File Menu.
The Lookup Wizard dialog will open. You can elect to lookup values already
in a table (such as the ZIPCODE table you created); or elect to create a new
table and enter the data as you go.
4. In this example, select Lookup Values already in a Table, then pick the
ZIPCODE table. Follow through the rest of the wizard, and click Finish. This
should work for you.

If the User is accessing data via a Forms page, you will need to adjust the
Forms page to be sure and pickup the zipcode field.

Hope this helps, this is what you are looking for?

Bobo
 
What the user wants in this case is to type in the zipcode and automatically
be able to choose the city and county that the zipcode relates to and have
these values when selected to fill the field on the form. Hopefully, this
describes the problem better for you if not please let me know. Thanks in
advance for your help.
 
Back
Top