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.