Find duplicate values operator found all values, even if there are no duplicates
Filemaker 11 Pro Advanced, FileMaker 13v4 trial
Operating system version
Description of the issue
Search records with duplicate values operator (!). It finds all records instead of duplicates.
Steps to reproduce the problem
Open filemaker database from here:
Search duplicate values in field OutlookID with ! operator - all records are found. That result is wrong because values in the field are different.
Try to search in text field or number field below, results are ok.
! operator should find real duplicated in field OutlookID (or no records).
All records are found.