Deduplicating Audit

[simoncpage]

Hi all,

I am about to start on deduping a database of about 10,000 contacts and 9,000 odd companies. I would like to be able to create a separate database to track which ones i delete change etc. Can anyone point me in the right direction?

Thanks in advance

Simon

-----

[email protected]

[ESpringer]

How about not deleting right away, but making "tag for deletion" and "tag as changed" (if you need to track that separately) fields?

Go through and tag clear duplicates, and when you're about to change a record without deleting it, make a duplicate tagged as "changed", putting your changes in the original. Then find all the tagged records (both kinds of tags, if you separate them) and EXPORT those records (using FMPro format). Then go ahead and delete those with both tags...

-ESpringer