A READER ASKS: Dealing With Duplicates

From Dwayne Wright - Certified FileMaker 9 Developer
TWITTER: dwaynewright

I built a very small database then cloned it 8 times. I used the file to store gathered data on the same subject, four fields total. The field that cannot be duplicated is the email address field. Now I know that when I merge them I will have, and cannot end up with duplicates. Would you PLEASE tell me? How to merge them so I don’t end up with duplicates

Well, the process involves targeting the duplicates and then removing them. There is a method using scripts that loop but the problem is that it is dependent upon the execution of the script. Here is a link to some recent posts I did on that technique...

Find Duplicates Via A Loop
EXAMPLE: Delete Duplicates Via A Loop

Now, a fresher technique involves using a self relationship and I would recommend you give it a try. It will allow you to create a calculation field that will indicate any record as a duplicate whenever it would occur.

EXAMPLE: Flag Duplicates Via A Relationship
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.
====================== ADVERTISEMENT ==============================
Click Here To See The FileMaker Book (via a blog) homepage!