I have an app of for a foreign language school and I want to create a schedule for their lessons
The students give the day and the hours they have obligations and they couldn’t be in their lesson of the school
I have a table OBLIGATIONS with
for their obligations outside of the school.
They can’t attend their classes between START HOUR and END HOUR for the specific day
I have created a form with three free fields
I want for a specific day of a week and for a range between A HOUR and B HOUR, to select all the students they don’t have obligations.
I want to be sure that between A HOUR and B HOUR for a DAY they don’t have obligations from the table OBLIGATIONS (for this DAY and the range between, START HOUR and END HOUR)
I would appreciate your help