Hi, I was asked to take over departmental rota in a hospital. My predecessor did it in Excel, I want to do in in access. I posted a question about this project in another thread and received suggestions that prompted me that my approach to the database itself may be wrong. Our rota is done for 6 weeks. It covers consultants activities and trainees only. There are mainly 4 types of activities including MDT meetings, absences, supervision of trainees, specialised work allocation, other activities. I have to keep these activities in separate tables for registration because they would have different fields and different number of fields.
My question is: Do i need to start with the the first and main parent table Date register where I will define all the dates first? Or may be another first parent table for Rotas id and then second parent for dates?
Any suggestions please? Has anyone did a similar job?
My question is: Do i need to start with the the first and main parent table Date register where I will define all the dates first? Or may be another first parent table for Rotas id and then second parent for dates?
Any suggestions please? Has anyone did a similar job?