Finding and eliminating duplicate records is an important part of maintaining a clean contact database in GoldMine. We’ve covered merging tagged records here:
http://www.thegoldmineblog.com/2009/03/time-for-some-goldmine-spring-cleaning-with-mergepurge/
After a merge/purge GoldMine will put the non-surviving record in the Additional Contacts tab.
If you are diligent, you will delete that right after the merge/purge, but of course we’re not all quite that perfect!
So here’s a SQL Query to find those so you can remove them.
To use this, from GoldMine’s main menu choose Lookup | SQL Queries then copy & paste the above in the top section then click Query. If you are using GoldMine Premium Edition then Tools | Filters & Groups and then the SQL Query tab.
select contact1.company, contact1.contact, contact1.phone1 from contact1, contsupp where contact1.contact = contsupp.contact and contact1.accountno = contsupp.accountno order by contact1.contact
Loading ...
{ 2 comments… read them below or add one }
that is good for finding them. Is there a way to delete all as well
Right-Click | Delete on the secondary contact to delete. If you want to do it en masse you’ll need to use a tool like GoldBox.
You must log in to post a comment.