Adobe v7 merge records function | Community
Skip to main content
Level 2
December 18, 2018
Solved

Adobe v7 merge records function

  • December 18, 2018
  • 4 replies
  • 4453 views

When two records are merged in adobe using the update activity, any transaction history (broadlog, tracking, etc) that was tied/associated to losing record, will all that get tied to the winning record id? or not.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by sourabhk3112

Hi Tasheen,

If you are replacing losing recipient with winning recipient then for associating transaction history tables you have to update the primary key of winning recipient with foreign key of losing recipient in transaction history tables.

Regards,

S

4 replies

sourabhk3112Accepted solution
Level 2
December 19, 2018

Hi Tasheen,

If you are replacing losing recipient with winning recipient then for associating transaction history tables you have to update the primary key of winning recipient with foreign key of losing recipient in transaction history tables.

Regards,

S

Level 2
December 20, 2018

Thanks Sourabh, thats what I thought. Appreciate the help!

EggBoy
Level 3
December 20, 2018

Hi, so just to make sure I understand, the merging of the two records does NOT really merge them unless you "update the primary key of winning recipient with foreign key of losing recipient in transaction history tables."  So, unless that is done, you are not truly merging the recipients, correct? Is there an easy way to update the foreign key?

Thanks,

Eugene

Level 3
December 26, 2018

In this case, wont the logs of losing recipient which had a different primary key get deleted/removed?