I have a database with follow recordfields: check in, check out and roomnr.
i set check in and roomno in index as unique same as roomnr. and checkout so that no overbooking is possible but between the to dates i couldn't make the dates to unique in combination with the roomnumber
for exemple ...