Creating Relationship Links in Dynamics CRM

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
gordonc
Posts: 1
Joined: Thu 22 Feb 2018 09:06

Creating Relationship Links in Dynamics CRM

Post by gordonc » Thu 22 Feb 2018 09:08

Hi.

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

Gordon

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Creating Relationship Links in Dynamics CRM

Post by Pinturiccio » Tue 27 Feb 2018 11:18

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

Post Reply