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!
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.