Title
Not finding duplicates
Post
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
After performing the find, did you sort the records so that the records with values were adjacent to each other?