Dynamics 365 connection table and account table - self referencing problem

[rickylee]

Hello,

I have Dynamics 365 CRM which has a database comes with it. There is a table called accounts and it is self referencing through a table called connections. 
The reference key in Account: accountid
Reference keys in Connections: _record1id_value, _record2id_vlaue

I can create a relationship between accountid to _record1id_value but cannot create another relationship between _record2id_vlaue and accountid.




Is there a way to solve this problem?

Thanks,
Ricky

[rickylee]

@Greg_Deckler
I choose to re import the same table althought not sure it is the best solution but the best solution so far 🙂

Thanks,
Ricky

[Greg_Deckler · Accepted solution]

You should be able to create the connection but it should get created as inactive. You can use USERELATIONSHIP in your calculations to determine which one you really want to use at a given time.

Another way to do this would be to import Connections table twice or Accounts table 3 times possibly.

Hard to say really though as it's not apparent what exactly you are trying to accomplish overall.