Hi
I have browsed the web and this forum but cant seem to find a solution to my question. (although there are many questions on the same topic).
Basicly, I am building a customer appointments database. The end result will be a system where the user can book/delete/amend appointments (with pre set time 15 minute slots) and by clicking on the name in a particular slot be able to view the client record details. There will need to be 4 seperate 'diarys' seen side by side.
I am happy with the client record details bit, however my queston is this.
What would be the best way to set up the table that holds the appointment slots? I need to be able to see the name of the cliet in a particular slot, and the reason for the appointment.
The only way i can see is to have 4 tables (one for each diary)
each table would have a new row for each appointment date and time. For example row 1 would be 01/06/2011 at 08:00. Row 2 would be 01/06/2011 at 08:20.
The problem with this is that there would be 36 time slots (rows) per day. This is going to result in a massive data table and the problem of manualy entering each date/time in advance.
There must be a better way to set up the tables for apointments? Do any of you have any suggestions? I have searched for examples with no luck, and have considered outlook, but decided this would not be suitable.
So, help. I know setting up an appintments diary is a big, complicated task, so i want to have the most effective way to hold my data.
any suggestions appreciated.
Sean
I have browsed the web and this forum but cant seem to find a solution to my question. (although there are many questions on the same topic).
Basicly, I am building a customer appointments database. The end result will be a system where the user can book/delete/amend appointments (with pre set time 15 minute slots) and by clicking on the name in a particular slot be able to view the client record details. There will need to be 4 seperate 'diarys' seen side by side.
I am happy with the client record details bit, however my queston is this.
What would be the best way to set up the table that holds the appointment slots? I need to be able to see the name of the cliet in a particular slot, and the reason for the appointment.
The only way i can see is to have 4 tables (one for each diary)
each table would have a new row for each appointment date and time. For example row 1 would be 01/06/2011 at 08:00. Row 2 would be 01/06/2011 at 08:20.
The problem with this is that there would be 36 time slots (rows) per day. This is going to result in a massive data table and the problem of manualy entering each date/time in advance.
There must be a better way to set up the tables for apointments? Do any of you have any suggestions? I have searched for examples with no luck, and have considered outlook, but decided this would not be suitable.
So, help. I know setting up an appintments diary is a big, complicated task, so i want to have the most effective way to hold my data.
any suggestions appreciated.
Sean