Double Booking Prevention
The booking system I am creating stores bookings using forms.
The user selects the accommodation type using a drop down list, then proceeds to enter the arrival date and then the departure date.
How would I prevent the user from entering double bookings?
So if they selected "Family Room"
And entered "20/02/2015" as the arrival date
A error message would display if, for example,
A booking already existed for the Family Room, where the arrival date is the "15/02/2015" and departure date is "23/02/2015"
So if the accommodation required and arrival date falls between the arrival date ... departure date then the error message informing the user of an attempt to double book occurring is displayed.
Thanks in advance,