Page 1 of 1

Creating Relationship Links in Dynamics CRM

Posted: Thu 22 Feb 2018 09:08
by gordonc
Hi.

In Dynamics CRM, how do I create record relationships such as linking a contact to an account?

Gordon

Re: Creating Relationship Links in Dynamics CRM

Posted: Tue 27 Feb 2018 11:18
by Pinturiccio
Please describe in more details what exactly you want to do.

If you want to select data from Contacts and related Accounts then you can use the following query:

Code: Select all

SELECT c.*, a.* 
FROM contact c
LEFT OUTER JOIN account a ON c.parentcustomerid = a.accountid