I have to deduplicate large databases on a regular basis and just switched from fp5 to fp7. The script I had written for my fp5 database involved building a calculation field from the name and address fields, setting a global field to the calculation field and comparing to the next record's calculation field. If they are the same it sets another field with an 'x'. I can then search for the x's in that field and find my duplicates.

It works great, but I am looking for 1. how to use the global field in fp7 (it seems vastly different than 5) and 2. is there a better way to de-duplicate my lists?

Thanks for your help, I can attach a file if it will help.

Globals aren't too much different, except that they can now be any field type except summary. You can create whatever type of field you want, with validations and auto-enter calculations, etc. and then set it to be a global.

See how this works for you: Create a self-relationship using your calculation field. Then create a calculation field of serial = selfrel::serial. Performing a find for 1 in this field will return a set of only unique records. Performing a find for zero (or 1 with Omit selected) will return all records that are duplicates of the unique set.