Hi, I am programing a database in MS Access for WIN95.
I am somewhat struggling with SQL, and need to know the following..
I have a main table called ROLEDEX, and in it are several fields which
include Zipcode, city, and state.  I have a seperatae table named
ZIPLIST with tons of zipcodes, along with thier corresponding cities
and states.  What I need to do, is join the zipcode, city, and state
fields from the ZIPLIST table into the ROLEDEX table that contains
those fields.  So, when a zip is entered in the ROLEDEX  table, the
city and state will be automaticly filled in (with information from
the ZIPLIST  table).

I would appreciate greatly, any information that might prove helpful
to my problem...
Thank You!  
---Jeff---

Hi,

Call up the relationship menu.  Make a one to many relationship for the
two tables. The zip table will be one and the main many as you can have
a number of same zip codes in the main relating back to one zip code in
the zip table.

Creat a blank query.  Add in the two tables, select the fields from both
table that you wish to have appear on your form/report.  Create a form or
report based on the query instead of the table and that should do it.

If you still are having problems drop us an email,
Jim

+-----------------------------------------------------------------+
| Jim Barrett,                          Title:  Software Engineer |

| Neptune House,                        Phone:  +353-21-317001    |
| Victoria Road,                        Fax:    +353-21-313603    |
| Cork City, Ireland.                   Mobile: +353-87-573121    |
+-----------------------------------------------------------------+

In the form, place the zip field from the ROLEDEX table. When a
zip from the zip code table is entered, Access automagically
looks up the balance of the data from the zip code table and
fills in the controls bound to the zip code table. The zip code
field from the zip code table does not need to be included in the
query.

For a more complete explanation, search help for "autolookup".

Joe

Never underestimate the power of a WAG.

http://www.citilink.com/~jgarrick

2) Design a query in the QBE builder which provides all the information
from the other rolodex table that you will need for the form, and links
the zipcode in this table to that in the ZIPLIST table.  Provide the rest
of the fields from the ZIPLIST *except* the zipcode.

3) design a form based on the query.  When you fill in the zipcode, the
other fields will be filled in automatically.  

Have fun.

Clyde Davies