Hi

We run a community centre which provides training, rooms for events, a
nursery and a creche.

I currently have a database set up as follows:

Child Users - Child User ID
Child Nursery Users - Child User ID
Adult Users - Adult User ID
Adult Nursery Users - Adult User ID
Custodianship - Child USer ID and Adult User ID

This is enough for me to monitr the users of our centre. I now need to set
up a booking system, so that I can book children into the nursery (no more
than 35 at one time), book children ino the creche (no more than 8 at one
time), book adults onto courses (variable limits) and then record their
attendance, and book out our rooms (together with catering and equipment) for
external events.

My main problem is placing limits on the number of people attending at a
given time. Though general suggestions on the structure would be very very
welcome.

Thanks a lot

Carlo