4 Replies Latest reply on Jan 16, 2015 12:47 AM by tomasd

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

    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.