De-Duplicating a database, global question

[kwvr200]

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.

[-Queue-]

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.