This content has been marked as final. Show 2 replies
Several ways to do this, two that pop to mind are:
- Create a calculation field that joins the Date and Resource fields (something like Resource & " " & Date), then search with the ! on that calculated field.
- Create a relationship to the same table, where Resource matches Resource and Date matches Date, then check for related values in a script or with a calculation field.
Hope that helps,
Thanks Chad. Why didn't I think of this (lack of experience I suppose)?