General discussion

Locked

Design an MS Access form with 2 subforms

By DonJG ·
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.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DonJG In reply to Design an MS Access form ...

Point value changed by question poster.

Collapse -

by john_wills In reply to Design an MS Access form ...

Both of your subforms should be continuous. Each subform should have, from the main form, child keys set to program and date from the main form. Each child form should have data from the appropriate table (attendance?) with joins to the substantive tables (client, staff?) to fill the form.

Back to Desktop Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums