Hello TIA,
What is the entity that you track student attendance for? Is it for class
- and division
is just a filter for either class
or student
? Or do you track students for a combined attendance (class
+ division
)?
In any case, the most important part is how you setup your relationships. Something like:
attendance
- (n:1)
class
- (n:1)
division
attendance_student_nm
- (n:1)
attendance
- (n:1)
student
Or simpler - if you just need to assign students to classes:
class
class_student_nm
- (n:1)
class
- (n:1)
student
Once you have your relationships, you should use the entity that you assign your students to, as base relation on a form - either attendance
or class
(see examples above).
On the form you can then add input fields for n:1 division
& n:1 class
and then use a n:m
input field to assign multiple students. If you only have a few students to select (if you use division
as a filter maybe) than you can select the option 'category input' for the n:m
input field and have a checkbox list to assign attendance. We currently cannot use regular lists as inputs - we use n:m
inputs for this purpose.