AnsweredAssumed Answered

How do I create a school timetable in Filemaker 11?

Question asked by andrewmcc on Jul 4, 2012
Latest reply on Jul 13, 2012 by petertj

I want to create a database to track the absences of teaching staff and allocate colleagues to cover their classes when they are off. As part of this I want to include the master timetable in the database. I am having difficulty with this. I don't know how to set up the classes so they they repeat, say every Tuesday at 11.00am from now until 31 May 2013. Can someone help me?

 

I am also planning the following tables in my database. I am looking for advice on whether this is sensible. Any advice gratefully received. I am new to this. I am working my way through the tutorials but I hope someone here can help!

 

 

Table 1 = Staff

__pkStaffID

Title

Surname

Forename

PostName

Department

ContractType

NonContactAllocation

NonContactActual

 

Table 2 = Attendance/Absence

__pkAbsenceID

StartDate

EndDate

CategoryofAbsence

Times

Reason

 

Table 3 = Classes

__pkClassID

_fkStaffID

ClassName

Department

Room

MeetingTimes

 

Any advice gratefully received.

Thanks

Andrew

Outcomes