1 2 Previous Next 18 Replies Latest reply on Jul 20, 2010 4:19 PM by AlPhuket

    constrain found set - > omit duplicates doesn't find a unique value

    AlPhuket

      Summary

      constrain found set - > omit duplicates doesn't find a unique value

      Product

      FileMaker Pro

      Version

      10

      Operating system version

      OSX 10.6

      Description of the issue

      The database has a field of serial numbers and dates.  When I perform a Find using a date, I get 3404 returns.  I then sort by the serial number and most serials are in the list twice, but one serial number is only in the found set once.  I then go into find mode again and select "Omit" and find duplicate values in the serial number list, and the result I get is no records.  The serial number I am looking for is in the database several times, but only once on the day of the first found set that I am trying to constrain the find to.

      Steps to reproduce the problem

      Serial Day
      123456 14
      123456 14
      123241 14
      123232 14
      123232 13
      123241 13
      123241 13
      Find "13", then go into Find mode and "Omit" "Find Duplicates" in the Serial number column

      Expected result

      Serial Day
      123232 13

      Actual result

      No records match

      Exact text of any error message(s) that appear

      No records match this set of requests

      Workaround

      Find on the day (=13)
      Export Records
      open new database of exported records
      find -> Omit -> Duplicate Values
      then I get the correct result (123232)

        1 2 Previous Next