topic Re: Preserving AccountContactRelation records for Duplicate Contacts in DemandTools

Preserving AccountContactRelation records for Duplicate Contacts

heidik — Tue, 29 Jul 2025 17:23:39 GMT

Hello! We rely heavily on the AccountContactRelation object. The trouble is that the non-winning Contacts' ACRs are also deleted when merging duplicate Contacts. I'm in search of creative ways to preserve, merge or store those AccountContactRelation records so the winning Contact gets all the winning and non-winning ACRs. There has been an idea out on the IdeaExchange for 8 years with limited traction. We're approaching the point where we'll probably build a custom Apex or scripted solution but I'm hoping Demand Tools can help get us close! Has anyone come across this issue and found a scalable solution?

Re: Preserving AccountContactRelation records for Duplicate Contacts

Pugs_Validity — Tue, 29 Jul 2025 20:26:57 GMT

@heidik - I'm glad you came here first! Thankfully, DemandTools can help out here without any customization. When using Dedupe to perform Contact merges, since ACR relationships can not be edited, DemandTools will recreate any ACRs from the non-winning Records with the winning record as part of the merging process.

Re: Preserving AccountContactRelation records for Duplicate Contacts

heidik — Tue, 29 Jul 2025 21:41:51 GMT

Oh ya, I totally forgot about this amazing piece of functionality! This is why we continue to be longtime DT lovers. Thank you!