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
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
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.
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.
