Reservation System

[nsidney]

I'm trying to figure out the best way to make a reservation system (for a daycare) that has the basics (check-in, check-out, name, date, time start, time end, actual billable duration, etc), but I also would like to be able to monitor how many kids are in each of 3 age groups at any given time and allow or restrict new reservations accordingly.

 

For example, the infant age group can only have a max of 4 at a time, the toddler group can have 12 at a time, and the kids group can have 20 at a time.  Everything is booked in 15 minute increments.

 

Any ideas on an effective way to accomplish this?

 

Thanks!