Not finding duplicates
I'm creating a new database, so far 7 records imported from a csv file. First field is orderid which has duplicate values. Performed a find with the ! operator and FileMaker found no duplicates. Tried a second field (name) which also had duplicates, again nothing found by FileMaker. Same result when I created a calculation field and also when I created a text field and manually entered duplicate values. What is set wrong?
Thank you, Frank
Yes. Sorted before and after in table view. I have attached a screen shot of the data - after looking for duplicates.
Duplicate values in which field?
Or are you trying to find records where the values in ALL the fields are matching duplicates? The ! is intended to find records with duplicate values in a single field so if you are trying to find records where all the field values match, you'll need to use a different method.
Mea Culpa - after much re-reading and finally getting it through my head. The ! operative finds records with duplicates - I kept thinking it was supposed to find unique. I wrote the necessary script to find unique records once I had identified the duplicates. It's working now. Thank you for your time and patience.
After performing the find, did you sort the records so that the records with values were adjacent to each other?