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.
