My teachers need to record all the dates when a student is absent. We do not need to record present, just absence.
We also need to easily count all of the time a student has been absent
One way to do it is for me to make an attendance table. The teacher can select a date and then link to the student table with all students who were absent that day/
Back on the student table side I can count how many dates were attached.
Is there a better way to do this??? One that would not me require me to create a completely separate table for attendance?