Fixed Booking System

[faith_scott]

Hi,

I was just wodnreing whether anybody knew how to design a fixed booking system for a database, as I ahve no clue how to do it,

Thanks in advance,

Faith

[OBonio]

Define 'fixed booking system' a bit more. Something like a court booking system at a sports centre?

[faith_scott]

Sorry, what I mean is, a fixed booking system for say a small company booking for say rooms etc. The booking has to be made via slots, and I have no idea how I can go about doing it!

Thanks so much for replying,

Faith

[OBonio]

So, a table for the Rooms :

RoomID - uniqueidentifier (or AutoNumber) - Primary Key
RoomDescription - varchar(255)

A table for Bookings :

BookingID - uniqueidentifier (or Autonumber) - Primary Key
RoomID - uniqueidentifier - Foreign Key on Rooms table
BookingStart - datetime
BookingEnd - datetime

And that's about it, apart from checking the BookingStart and BookingEnd fields each time you try and create a new booking to ensure no bookings clash.

[jennifer_cro]

if you use exchange you are probably better off setting up a public folder called Meeting Rooms (or something) and then having a diary for each room.

[faith_scott]

Thank you so much for your help!

[mattfox]

Access has a "Resource Booking" template that you could work on and modify...