Prevent record addition based on previous record dates.

[Mike Jeffreys]

Hi all,

I am building a simple bookings DB for a guest house. I have a main table (Bookings) that has the details of bookings that have been made, Name, Date & so on. Have a form that allows the addition of more bookings.
What I would like to do is prevent any further bookings being made on dates that are already full up i.e. already have 6 bookings.
So, on the bookings form, if somebody enters a date which already has 6 bookings on, the booking cannot be completed & a message is displayed to the user.

Thanks in advance for any help.

[orange]

When you are filling a form to add bookings, you must check to see that you have some "rooms available". If no rooms are available, then indicate no Vacancy and prevent further booking/assignments.

See this in code repository

Here is a generic data model from Barry Williams' site that deals with Hotels and Reservations
It may have more detail than you need, but it is intended as a starting point - you can add, remove, edit as necessary for your needs.