My form won't let me enter new records

C

Cheryl48

I am very new to access, and am creating an address database. I'm tying to
create a pretty simple table for the contacts, and another table with zip
codes, cities and states. When I try to create a relationship between the 2
tables, to create a form to enter the data, it gives me an index message. Can
you help? The form, created from the query, won't let me enter new data.
 
L

Lynn Trapp

Cheryl,
When you say "index message" can you be a bit more specific about what that
is? Also, could you paste the table structure for your two tables and what
the recordsources is for your form.
 
C

Cheryl48

Well, actually, I figured out how to make the relationship work, but it still
won't let me input new data into a form that I created from a query with both
tables included in the query. I created 2 tables, one for the contacts, and
one for the zip code. The zip code one only has 3 fields, (zip, city and
state). The contact table has 31 fields. I created a query, sorting the last
and first names, using both tables, and created a form from that "alpha
query". I've gotten the tabs to cooperate (skipping over the city and state),
but the form will not allow me to enter a new record.
 
Top