Finding Duplicate Records Except First Instance Help
Thank you so much for your time and energy with your help.
Mac OSX 10.6.2
Beginning Level User to FMP & databases in general
Database size is over 10 Million Records
One of the fields in my database is an email field.
I know there are quite a few duplicates as I put in "!" in the Email field in Find Mode.
I want to identify and then remove the duplicate (as defined by having the same email) records from my database.
I have followed the 7 steps as outlined in the FileMake Pro Help, "To find duplicate records except the first instance" but I must be doing something wrong.
Once I am done, in the Check Duplicates field every record has the word "Unique" in that field instead of them separating with some "Unique" and some "Duplicate"
Please advise....thank you.