I have a simple two table database in FMPro 11, linked using a blended key. On one layout in my main table, I include a linked text field from the second table. If, on the main table, I do a "Find Duplicates" search on this linked text field (using the '!' operator), and then sort the results, it appears that the results of the Find command includes unique values as well. I've attached a screenshot to show the problem.
Can anyone help me understand why this Find command is not working as expected, or what I can do to improve my confidence that the '!' Find is working properly?