+ Start a Discussion
angusgrantangusgrant 

de-duplicating Contacts for Custom Application

Hi I have created a custom application using the object/database scheme shown in the link bellow.

 

http://www.gliffy.com/publish/1673148/

 

"Applicants" is the object Contacts

"Organisations" is the object Accounts.

 

All the other objects/tables are custom salesforce objects.

 

Including Applications__c in which There can be many applications for a given contact. The application__c object has an ContactID field that maps to the ContactID record on the Contact object.

 

Is there an application available on appexchange that can easily deal with this scenario and will allow for the automatic deletion of duplicate records in the application__c object/table when contact records are merged together? Or possibly a way in apex of having an automatic cleanup opportation that will clean out orphaned records in this custom table.

 

Thanks for your help in advance.