>FileMaker can weed out dup records based on any field or set of fields. I >forget the exact method,
The easiest way that I know (and the way I handle it here at work) is to search for duplicates on a field you know shouldn't BE duplicate (ie: a field that IF duped, means the record is 99% likely to be a duplication). With email addresses this is a peice of cake as the address should always be unique. To search for dupes, enter Find mode, then put in a "!" and perform the find. Then sort by the field you just searched on. This will put all the dupes right in a row together. Quickly scanning thru and you can delete the dupes (you can actually set up a script to do it automatically, but that is a bit of effort if you only have a handful to go thru... I use scripts whem I am de duping thousands of records with hundreds of duplicates). If it were me, I would first search on the email address, that will remove pure duplicates. Then search on the first/last combo (make a new text field and set the contents to the first name and last name). That will remove pure name dupes (and let you merge unlike email addresses for the same person). Then do two more passes, one of the first name only, one on the last name only. That will root out potential duplicates with mispellings. This last step may be over kill depending on how seriously you want to do this. -chris <http://www.mythtech.net> ___________________________________________________________________________ To unsubscribe send a mail message with a SUBJECT line of "unsubscribe" to <[EMAIL PROTECTED]> or <[EMAIL PROTECTED]>
