AnsweredAssumed Answered

Find duplicate values operator found all values, even if there are no duplicates

Question asked by tomasd on Jan 15, 2015
Latest reply on Jan 16, 2015 by tomasd

Summary

Find duplicate values operator found all values, even if there are no duplicates

Product

FileMaker Pro

Version

Filemaker 11 Pro Advanced, FileMaker 13v4 trial

Operating system version

Windows 8.1

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:
https://onedrive.live.com/redir?resid=441FE79284753018!4199&authkey=!AG-5bXlgE6WPw1A&ithint=file%2cfmp12

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.

Expected result

! operator should find real duplicated in field OutlookID (or no records).

Actual result

All records are found.

Outcomes