cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Recreating Referential Integrity between imported entities

Hi,

 

I wonder if someone can point me in the right direction

 

I have imported some data into Dynamics CRM, and am trying to restore data relationships between records in different entities, e.g. contacts and organisation, or contacts and notes.

So, I have imported the old reference field in both entities:

 

Contacts:                                                        Organisation

Old Parent Ref  <=============>      Old Account ID

 

Parent Account  <=============>      Account ID

 

Can someone kindly advise how I can now update the CRM Parent Account field to restore the relationship with the data I have?  I have a pretty good idea how I'd do it in SQL, but not a clue how to do it here ...

Thank you in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Recreating Referential Integrity between imported entities

4 REPLIES 4
Highlighted
Microsoft
Microsoft

Re: Recreating Referential Integrity between imported entities

Hi @AngeloA,

Have you tried posting this question in the Dynamics community forum? The URL is the following: https://community.dynamics.com/

 

Perhaps there would be more easier to have an answer to your question, since that forum is more suitable for Dynamics 365 CRM related questions.

 

 

Hope this helps!

 

Regards,

Ricardo

Highlighted
Super User
Super User

Re: Recreating Referential Integrity between imported entities

Highlighted
Helper II
Helper II

Re: Recreating Referential Integrity between imported entities

Thanks @rimatos
Highlighted
Helper II
Helper II

Re: Recreating Referential Integrity between imported entities

Thanks @Drrickryp, sorry this was posted twice, it was marked as spam originally, so I did the other post, and then this unmarked as spam so it shows twice...

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Users online (8,473)