HI Matthew;
You can create formula check box in the table to see if there is any record conflicting:
This formula will show if it is okay to create record for those time:
var text recs=GetRecords("{xx.OAF.'"&[Start Time]&"'}AND{'xx'.OBF.'"&[End Time]&"'}", "aaaaaa")
if($recs="", true, false)
In this formula:
xx= Field id of Start Time
aaaaaa=Table Dbid()
You can add more conditions to query above.
After you create this field you can create form rule to prevent user to save record if this checkbox field is true. Or you can create notification to be triggered when record is added and this checkbox field is equal to checked.
I hope this helps.
------------------------------
Razi D.
WEP Forms
http://www.destatechs.com------------------------------
