I have a requirement for Hall booking. There are multiple halls to book from dropdown. I need to restrict two users to select same hall on same date at a same time. Can you please help me on this.
Thanks in advance
One way to simplify this is to create a Calculated field that is on the list that has the Hall name and Date Time. Then your query will compare the New Items calculated value against all of the calculated values in the list. This way you are only looking at one field for the comparison instead of two or three.
An alternative way is to use a workflow and have it notify the user that they have a conflict.
Retrieving data ...