Adobe v7 merge records function | Community
Skip to main content
Level 2
Dec 18, 2018 9:09 PM UTC
Solved

Adobe v7 merge records function

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.
sourabhk3112Accepted solution
Level 2
Dec 19, 2018 12:33 PM UTC

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

Level 3
Dec 26, 2018 5:36 AM UTC

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

Translate
EggBoy
Level 3
Dec 20, 2018 4:36 PM UTC

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

Translate
Level 2
Dec 20, 2018 3:21 PM UTC

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

Translate
sourabhk3112Accepted solution
Level 2
Dec 19, 2018 12:33 PM UTC

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

Translate