AnsweredAssumed Answered

Finding Unique Records

Question asked by FrankBurkhart on Nov 13, 2013
Latest reply on Nov 13, 2013 by Fred(CH)


Finding Unique Records


FileMaker Pro



Operating system version

OS X Maverick

Description of the issue

Using the unique operator (!), Filemaker does not find any duplicates.  Database is only 7 records and I see that there are 4 non-unique items based on order number.  I tried looking at order number and then on name and didn't find any duplicates.  I created a calculation field using three fields, again visually could see the duplicates but nothing found by FileMaker.  Last, I created a text field, manually entered duplicate values, again without success.  Obviously I have something set wrong somewhere. Old time FileMaker user so this really has me baffled.


Steps to reproduce the problem

Entered (!) and perform find in a single field

Expected result

Duplicates not found

Actual result

All records found