Hello!
Have been writing a database for the clinic where I work over the last few days, and have completed everything that I need to except for this, which is the biggest, and I haven't a clue how to tackle it.
I want a Form that across the top has a List of Counsellors (4-6 in total, depending on day), and down the side has allotted time slots (3 times), but varies on date selected. Every Date has a different list of Counsellors at the clinic. They need to autoload when the correct Day of the week is selected (So when the date is 13/08/2012, then all Monday Counsellors would load across the top). The Time remains the same, regardless of day.
Next is the actual bookings. With up to 6 Counsellors each with 3 different time slots, the form could have up to 18 bookings that day (and therefore, 18 subforms). Each Subform must contain the same information (Client ID, Session Type, Attendance and Notes), but when data is entered into these subforms, then they must also know to include the Date, Time and Counsellor automatically as allocated by the position they are in, eventhough that data isn't inputted by the administrator.
My problem is that I haven't a clue what tables to build, what queries to run, nor how to compile the main form (I know how I want the subforms to look).
I have compiled the 'look' of what I want in a MS Paint document attached to this post. If anyone could steer me towards how to accomplish this best, I would be incredibly greatful, or point me to a demo database that someone else has published that does something similar, I am sure I could dissect that and adapt it to my own needs.
Many Many thanks in advance!
Davron
Have been writing a database for the clinic where I work over the last few days, and have completed everything that I need to except for this, which is the biggest, and I haven't a clue how to tackle it.
I want a Form that across the top has a List of Counsellors (4-6 in total, depending on day), and down the side has allotted time slots (3 times), but varies on date selected. Every Date has a different list of Counsellors at the clinic. They need to autoload when the correct Day of the week is selected (So when the date is 13/08/2012, then all Monday Counsellors would load across the top). The Time remains the same, regardless of day.
Next is the actual bookings. With up to 6 Counsellors each with 3 different time slots, the form could have up to 18 bookings that day (and therefore, 18 subforms). Each Subform must contain the same information (Client ID, Session Type, Attendance and Notes), but when data is entered into these subforms, then they must also know to include the Date, Time and Counsellor automatically as allocated by the position they are in, eventhough that data isn't inputted by the administrator.
My problem is that I haven't a clue what tables to build, what queries to run, nor how to compile the main form (I know how I want the subforms to look).
I have compiled the 'look' of what I want in a MS Paint document attached to this post. If anyone could steer me towards how to accomplish this best, I would be incredibly greatful, or point me to a demo database that someone else has published that does something similar, I am sure I could dissect that and adapt it to my own needs.
Many Many thanks in advance!
Davron