Posted - 02/14/2013 : 18:58:54
| I am looking at transferring our current spreadsheet roster to a database. There are 5 parts to the data.
Staff Details - Firstname, Surname, staffid etc
Roster Details - rostertype (Onsite,R&R, Annual Leave ect)
Duty Details - each 3 months a persons duties are changed in a rotating system (Duties like Cleaning, Cooking, Maintenance etc)
I would like the output to be based on a date range so I need to assign each Day a roster type for each staff member, then a duty type for that date as well.
Is the best option top have a table for each detail (Staff, Roster, Duty) which includes a date range for each particular item and then a view central table for Date, Staffid, RosterType, DutyType).
Or is there a better way?