Hi all. I have to design and build a room booking system in access and am not really sure where to start re. the structure. Basically we need a day calendar view showing hour slots - along the top are listed the rooms in the building, along the side are listed time slots (just like a calendar). I need users to be able to select a date from, say, the calendar control in access, so the above described day schedule appears, then click on a slot and type in their name, and that slot is then booked. And that's it...but now I'm getting down to it it's looking much more complicated than I'd originally thought..!

What I need is just some advice on how to go about structuring the tables/entities, or even suggestions on just what tables I shoud have to begin with, even that woud be a great help.

Please help, I feel like such a dunce!

Thanks (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)

Oh, and I have done extensive searches within these hallowed forums (fora?) for examples of booking systems, but haven't really come up with much that seems relevant. I may, of course, be wrong and have missed something...

Edited by: teresa1 on Thu Mar 2 7:18:48 EST 2006.

Thought it would easier if I posted my current thinking on tables so you can laugh at them..(each tbl... in bold is the table name, with attributes listed underneath each):

tblCurrentDate
current_date_id
current_date

tblAppointmentRoom
Appt_room_id
Appt_room

tblAppointmentSlot
Appt_slot_id
Appt_start_time
Appt_end_time
Appt_type
Appt_worker
Appt_room

tblAppointmentType
Appt_type_id
Appt_type

tblWorker
Worker_id
Worker

Idea being each date has more than one appointment slot, each appointment slot has an appointment type and a worker. Or shoud it be that each date has more than one room, which then has more than one appointment slot..? There's something really fundamental I'm missing here - please help!

Take a look at this link for an example. It will give you a guide.

Accomodation

Dallr

Cool, thanks for that. I may be getting somewhere now...

Can anyone take a look at this structure, and give me some idea of whether I'm heading on the right direction, please..? Am I just making this way more complicated than it needs to be..?!