My database assigns jobs to one date and one resource manually. I have created a matrix (date vs resource) that shows which job has been allocated to which resource on which day but I would like to double check that I have not allocated more than one job to the same combination of date and resource (a resource can only work on one job on one day). I have tried using the "!" symbol in both of the fields "Date" and "Resource" simultaniously but Find returns most of the records as though it is using OR logic instead of AND logic. I have tried this in a scripted Find and via a manual Find.
Any ideas how to do this?