Jason Burds

Thanks for the quick reponse. Currently I am trying to do one table for all of the rooms. Do I need to make a seperate table or even seperate file for each room? Relationships don't seem to work with the 2 tables. Customer table and the Rooms table. And on the form I can get it to popluate but it still lets me enter in the same time on the same day for the same room. Where would I put this in Reservation::Date = Reservation 2::Date AND Reservation::Time Start <= Reservation 2::Time End AND Reservation::Time End >= Reservation 2::Time Start AND Reservation::Room = Reservation 2::Room is that a script off of the accept reservation button. Sorry for being such a newbie at this. Thanks again for your help.

Hello, everyone. This is my first time in the forums, and I am fairly new to Filemaker. My boss wants me to design a simple database that can keep schedules for 4 rooms. Where I am coming into problems is on the date and time validations. I am trying to figure out how to restrict someone from entering a reservation on the same time and date as another record for the same room. If this is not the right topic for this, sorry, please point me in the right direction.