I have created a database for a hotel booking & billing system, can't seem to stop from booking same room on sdame dates. Have indexed so that can't book in on the same day, but can still book the next day. Any clues?
Tullulah 0 Newbie Poster
griswolf 304 Veteran Poster
A little more detail might be helpful
Tullulah 0 Newbie Poster
What do u need to know?
There are several relationships, in the booking form there is also a sub form to inc the guests details
Booking form incs
Booking no
Date of arrival
date of departure
booking date
room no
guest no
no of adults
no of children
Have got it so that doesn't duplicate room if doa is same, but can't seem to do anything regarding dod, so could effectively book same room next night even if it's still booked
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.