Additional tables

[Guest]

I created a simple database a few months ago. It's not too terribly complex.
I have releationships between 4 basic tables, queries built off those
tables, forms built from those queries to input data, and reports. I've
worked with it relatively successfully inputting data and printing reports
and all, but now, there was a request to add an additional table to gather
more data. I've added that table, and created a relationship with the main
table, however data when entered into the new table will not save. I get an
error from the new table noting that there must be a corresponding record
from the main table.

However, that original table does have a corresponding record. Any ideas?
Thanks.

Terry Coverson

 

[jahoobob via AccessMonster.com]

How are you entering the data into the new table. Is it via a sub-form on a
form based on the main table? If it is, then you need to link the Child and
Master fields.
If your second table is just additional info for one record in the main,
consider adding the fields in the new table in main table.

 

[Jeff Boyce]

Terry

What is the relationship between the data in the "new" table and the data in
the "main" table? From your description, your main table has a record
(related to the new table). How did it get there? When you try to add a
new record in the new table, how are you doing that? Directly in the
table, or via a form?

As another responder points out, if the data is related one-to-many, a
sub-form approach works well.

Regards

Jeff Boyce
Microsoft Office/Access MVP