Add records

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

Guest

Unable to add a record when two tables are joined in the same query or form.
These two tables are related to each other.
 
Are these two tables joined together in the Relationships window with
Referiential Integrity enabled? If not you may have problems.

Probably the best way to add records in this situation is a form for the
parent table and a subform based on the child table. When you add a record to
the child table, Access should automatically link it to the parent table.
This will work if you have RI enabled as above and let the Wizard install the
subform.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Have both records from two queries/tables under one Query without related fields. 0
Add records via query in a one-to-may relationship 2
You can not add or change a record because a related record... 8
Append Query Issue 0
Seriously, I need ideas. Fields not transferring from table to table 3
One-to-Many join act as a One-to-One join 2
Help Disambiguate my Join 2
Non-updateable query issue 24

Back
Top