Custom Data Rul
Hi, I have a Facilities Table with a one-many relationship with a Rooms Table. The Rooms Table has the following fields; Related Facility (Numeric) which is related to the Facilities Table. ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI 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.com
mark.shnier@gmail.com
------------------------------
[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.com
mark.shnier@gmail.com
------------------------------
- Hi Mark,
Thank you that worked well.
------------------------------
Tim Egerton
------------------------------
