relationships

J

Jenny Calhoun

When i try to enter data in a form from 1 table is ok, but the fields from the joining table keep saying cannot add records;join key of table is not in record set. how do i fix this
 
J

John Vinson

When i try to enter data in a form from 1 table is ok, but the fields from the joining table keep saying cannot add records;join key of table is not in record set. how do i fix this
Click to expand...

Use a Form for the "one" side table, and a Subform for the "many"
rather than trying to use a query linking the two tables. Set the
subform's Master Link Field and Child Link Field to the joining fields
in the two tables.
 

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

Adding data to MS Access from csv file 0
Help creating a search form in Access XP 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Append Crosstab Query to Existing Table 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Split form 0
List all tables, including document structure 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0

Top