Microsoft Dynamics CRM (Archived)

Relationship between Account and Connection

(0) Share

Report

Posted on by Community Member

Hi guys,

I am trying to figure it out how link Account and Connection table in CRM Database.

Does anyone have any idea, please?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (4)

Verified answer

razdynamics 17,308 User Group Leader on at

Like (1)

Report

Hi Jose, On the Account record you will see the 'CONNECT' button on the toolbar, click this and the following window will open which will allow you to create a Connection with another record and allow you to define the Relationship / Role;

Hope that Helps :)

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

This link sent me to right track community.dynamics.com/.../sql-query-in-crm-2011-2013-2015-connection-entity

Thanks,

Was this reply helpful? Yes No
Suggested answer

Alagunellaikumar 6,212 on at

Like (1)

Report

Hi Raz,

Could you please tell me scenario what time should choose connection? I have read many articles But i cant understand. Could you please tell me real time scenario should i choose connection?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Thanks, But I am focus in the database.

Was this reply helpful? Yes No
Suggested answer

Alagunellaikumar 6,212 on at

Like (1)

Report

HI Jose

Please refer below link

missdynamicscrm.blogspot.in/.../sql-query-in-crm-connection.html

Was this reply helpful? Yes No
Verified answer

Abed Haniyah 4,287 on at

Like (1)

Report
When you add a connection between tow records, it actually add tow records on ConnectionBase table, one as master record ("IsMaster" = 1) and each one has aslo:

Record2ObjectTypeCode

Record1Id

Record1ObjectTypeCode

Record2IdObjectTypeCode

Record1IdObjectTypeCode.

The link between AccountBase table and ConnectionBase came on tow fields if you add a connection to an account, in master one :

Record1ObjectTypeCode = 1

IsMaster =1

Record1Id = AccountGUID

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

In the case that IsMaster = 0, where could I get the relationship between
Record1Id and AccountGUID?
Thanks

Was this reply helpful? Yes No
Verified answer

Abed Haniyah 4,287 on at

Like (0)

Report

Below is a sample of connection between Account (A) and Account (M), Im sure it will give you more information about how the connection store the data on ConnectioBase table :

You can try the query :

Select top 2 ismaster, record1id, record1objecttypecode As OTC,record1objecttypecodename As OTCName ,record1idname, record1roleid,record1roleidname, record2id ,record2idname

from filteredConnection

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Excellent! I really appreciate your response, Thank you.

Was this reply helpful? Yes No