college timetable need help

[Spiker]

Having faith in FMPro and being reasonably proficient in FM5 I volenteered to design a college timetable.

The basic components are rooms, lecturers, student groups and start & end times of classes. (Length of classes is variable). Maximum number of classes per day is 3.

I have tried to replicate the look of the present timetables done in Excel which is logical, days down the side and hours along the top.

There are room timetables, lecturer tietables and student group timetables. These are individual for each room, lecturer and student group.

I attach my solution to date.

It works fine to show room timetables though I realise that I should have one record per room rather that 5 being the days of the week.

As I set up databases and relationships for lecturers and student groups I am failing to link to all the occurances of any particular lecturer or any particular student group. This I am thinking I need to do to be able to build the calculation to form the timetable bars and do error checking. Can't have same lecturer or student group in two different rooms at the same time and can't have two lecturers or student groups in the same room at the same time.

Tried various approaches, scanned this and other FM sites to no avail. Perhaps there is another approach? I have a trial version of FM7 so am willing to get stuck in

to that if it offers a solution

AW_schedule_main.zip