Mark a roll

Mark a roll

Hey guys,

I am trying to build a fairly simple application to mark attendance. Four forms, People, Classes, Attendance, AttendanceDetails.

People with one field "Name",
Classes with one field "Class".
Attendance with two fields, a date field, and a subform "AttendanceDetails".
AttendanceDetails with two fields, one to one lookup for "Name" and one to many lookup for "Class".

Workflow is to enter the date, add rows to subform selection the name and classes attended.

The problem is that with 300 names it becomes quite tedious to work through.

Any more elegant solution possible?

I have looked into:
Adding and prefilling the subform rows with the list of names (possible up to 75 records).
Using custom actions on a report to create a button to add each class to a value when the button is pressed, works well for adding classes but doesn't seem possible to link to a date.
Using custom actions to create subform records on parent form report (doesn't seem possible).



Thanks!