AnsweredAssumed Answered

Finding Unique Records

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

Summary

Finding Unique Records

Product

FileMaker Pro

Version

12.0v5

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.

Thanks,
Frank

Steps to reproduce the problem

Entered (!) and perform find in a single field

Expected result

Duplicates not found

Actual result

All records found

Outcomes