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.