I have structured a table to record timetable data for classes with the following fields:
GroupID
DayNo
PeriodNo
SubjectID
InstructorID
RoomID
The DayNo ranges from 1 to 5, and each day has 9 periods represented in PeriodNo. There will be 45 records for a given GroupID.
I would like to have the period numbers across the top of the form and the day numbers down the left of the form. What to enter at the intersection of row (day) and column (period) are the other fields of SubjectID, InstructorID, and RoomID.
I am doing this for our timetabling officer who is currently using a DOS based application that presents the timetable on screen as I've described above.
I have created an unbound form with unbound text boxes and populate the controls through code when the form opens. It works but the form is very slow (may because I've used combo boxes).
Anyone out there have a better approach.
GroupID
DayNo
PeriodNo
SubjectID
InstructorID
RoomID
The DayNo ranges from 1 to 5, and each day has 9 periods represented in PeriodNo. There will be 45 records for a given GroupID.
I would like to have the period numbers across the top of the form and the day numbers down the left of the form. What to enter at the intersection of row (day) and column (period) are the other fields of SubjectID, InstructorID, and RoomID.
I am doing this for our timetabling officer who is currently using a DOS based application that presents the timetable on screen as I've described above.
I have created an unbound form with unbound text boxes and populate the controls through code when the form opens. It works but the form is very slow (may because I've used combo boxes).
Anyone out there have a better approach.