Using Microsoft Access, how do I design a form containing two subforms, linking the data to establish instant updates?
ProgramDate Form
The Form?s primary key should identify each unique combination of two specific fields: (1) a Program field; and, (2) a Date field.
Client Subform
The first subform should comprise a datasheet of Client records (First Name, Last Name, Level of Care, Hours) reflecting the attendance of each Client present at the Program and on the Date specified in the appropriate record of the ProgramDate Form.
Personnel Subform
The second subform should comprise a datasheet of Personnel records (Name, Status, Hours) reflecting the composition of staff at the Program and on the Date specified in the appropriate record of the ProgramDate Form.