Thank you @test_google for taking the time to create this demo.
This works! But… it appears to me that there should be a more elegant solution, without the need for:
a.) the extra field (Attendance) and
b.) the extra records that need to be added to ...
Hi Nachliel, thank you for reply! Unfortunately this is not where the issue comes up for me.
I have the following tables:
StudentCourseLesson
A lesson belongs to a course, so I have a junction table:
4. Course-Lesson
A student is enrolled into a cour...