AnsweredAssumed Answered

Bug with finding duplicates

Question asked by scottworld on Sep 19, 2011
Latest reply on May 3, 2013 by Fred(CH)


Bug with finding duplicates


FileMaker Pro



Operating system version

Mac OS X 10.6.8

Description of the issue

In find mode, FileMaker gives us the ability to type in ! (the exclamation point) in order to find duplicates on a certain field.

This works just fine, UNLESS you choose to "Constrain Found Set" instead of "Perform Find". Then, FileMaker doesn't always work properly. In the resulting found set, SOME records will be duplicates and SOME records WILL NOT BE duplicates at all.

So, because of this bug, there is no way to effectively search for duplicates WITHIN the current found set that you are looking at.