I think that you may be using the wrong technique care. I suggest that you simply mark the field
[
Facility_Room No Validation]
in field properties as being Unique.
However since there is no concept in your formula of which day the room is being booked for it seems to me that your formula needs to be expanded to deal with the same facility in the same room in the same day------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------