Hi, i'm having trouble in my database, my database is based on a hotel that deals with bookings and other details, however i cannot make many bookings for one room, and at the same time prevent the problem of the check in dates and check out dates overlapping one other. For example if someone checks in for a room for the date 1/1/06 and check out on the 3/1/06, another person should not be able to be booked in for that same room for the date 2/1/06 to the 3/1/06, as the room is not free at that time, however i do not understand how i could possibly deal with this problem, if you have any solutions to the problem written above please help me!