christopher007
Instructor
I have a table names Staff Members with fields, Name, Job and Area.
I have a second table names Courses Attended with fields Name, Course and Date.
I have a relation ship between Name and Name in the to tables, ref-integrity turned on and one to many shows ok in relationships.
My question is can I make a form with Staff members table and have a subform of Courses attended table on it.
If I add a new record in the subform will the Name field populate automatically due to the relationship ?
What I get in the subform is the main forms name for all new records and access says the records are read only if I add or edit any. I have checked for the obvious right back to the table.
Am I doing something wrong, is it actually possible to add a new related record in a sub form ?
Thanks in advance Chris.
I have a second table names Courses Attended with fields Name, Course and Date.
I have a relation ship between Name and Name in the to tables, ref-integrity turned on and one to many shows ok in relationships.
My question is can I make a form with Staff members table and have a subform of Courses attended table on it.
If I add a new record in the subform will the Name field populate automatically due to the relationship ?
What I get in the subform is the main forms name for all new records and access says the records are read only if I add or edit any. I have checked for the obvious right back to the table.
Am I doing something wrong, is it actually possible to add a new related record in a sub form ?
Thanks in advance Chris.