A READER ASKS
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...
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 firstname.lastname@example.org.
© 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!