Bug with finding duplicates
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.