i have a relationship between a subject version (1) table and a subject cover (2) table.
1 = subject/version
2 = people trained in subject/version
the join is a composite on subjectCode and versionNo.
my main form is from table 1. i then added a subform to 2. the parent child is set up as 1.subject = 2.subject and 1.version = 2.version
i can add new records to the parent form (1) but i can;t add new records to the subform (2).
am i missing something here? can i add new records to table which have composite keys on ??
Thanks
** edit. i can open the subform on it's own and i am able to add new records.
1 = subject/version
2 = people trained in subject/version
the join is a composite on subjectCode and versionNo.
my main form is from table 1. i then added a subform to 2. the parent child is set up as 1.subject = 2.subject and 1.version = 2.version
i can add new records to the parent form (1) but i can;t add new records to the subform (2).
am i missing something here? can i add new records to table which have composite keys on ??
Thanks
** edit. i can open the subform on it's own and i am able to add new records.