Community Centre Reservations

Hi there,

I work part time for a small charity in the UK that runs a community centre, and I
have been trying to find a way to computerise our booking system.

We are all volunteers and every database booking solution out there has either not
quite been what we need, or is a subscription service we cannot afford.

I figured I�d try and come up with something In access for everybody to use, but it�s
been a long time since I�ve done any database design and I�m struggling to wrap my
head around how I�m going to achieve certain things.

 I came across your site purely by accident but its great for getting ideas for structure.

Our Situation:
          Community Centre with 6 hireable rooms
          Bookings can be for multiple rooms at multiple times
          Bookings can recur on a weekly monthly basis (with optional gaps)
          Bookings can also be on an irregular schedule (random days)

I�ve been trying to wrap my head around a way of getting this working - and I just can�t get it.

I�m resigning myself to the fact that any booking for any day that is different will be treated as a separate booking.

Any advice, sample code, tutorials etc. would be greatly appreciated.

Thanks in advance

Neil