Kayleigh
Member
- Local time
- Today, 07:46
- Joined
- Sep 24, 2020
- Messages
- 706
Hello there,
We are working on a database which logs students individual lessons and attendance.
A key element is the timetable which must be viewed clearly, include subject, teacher and room for each lesson AND update on the fly.
I have enclosed a sample model. (Keep in mind that this is a special school where each child has an individual program.)
All data (except days of the week) are dynamic. Would it work to have a continuous form for each day of the week, which would display the sessions in order and detail teacher/subject/room and the times could change depending on the sessions input?
We would like to use this as a tool for timetabling so it should restrict a teacher/room which is already booked in for a session with another student.
All suggestions are welcome!
We are working on a database which logs students individual lessons and attendance.
A key element is the timetable which must be viewed clearly, include subject, teacher and room for each lesson AND update on the fly.
I have enclosed a sample model. (Keep in mind that this is a special school where each child has an individual program.)
All data (except days of the week) are dynamic. Would it work to have a continuous form for each day of the week, which would display the sessions in order and detail teacher/subject/room and the times could change depending on the sessions input?
We would like to use this as a tool for timetabling so it should restrict a teacher/room which is already booked in for a session with another student.
All suggestions are welcome!