web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Relating Site Entity to Account Entity

(0) ShareShare
ReportReport
Posted on by

Greetings,

I need to show the relationship of four tiers of accounts for customers that are medical providers:

  • Tier 1: I'll call the Health Network.  No medical services are provided at this level.  It is the business umbrella that all medical facilities below it are related.  Not all Organizations are under a Health Network.
  • Tier 2: Organizations are composed of two types.  Those with multiple sites and those without. 
  • Tier 3: Sites for which and Organization may have multiple.

I created the hierarchy relationship between Tier 1 and Tier2 using the parentid concept.

My question:  How do I create the relationship between the Organization and a Site Entity?

Using Business Management I created a couple of sites using the same name as the Organization.  The link was not made.  In many cases the name of the site will not match the name of the organization.  I would like to create the sites and the relationships during an import.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at
    RE: Relating Site Entity to Account Entity

    Hello

    Creating a Site with the same name as an Account will not create a link unless you have specified one should exist. The easiest way would be to create a 1:N relationship from the Account to the Site and then create a Lookup field on Site using the relationship. This would affectively work as a parent child relationship and you could display all the child records as a sub grid on the (parent) account.

    I'm not sure if you plan to use the Hierarchical View function to show this as a diagram, but I don't think it works with records other than Accounts. If that is the case, you will need to create a similar relationship between Tier 2 & 3. This would mean The Tier 2 Accounts are the parent of the Tier 3 Accounts, but a Tier 2 can still be a child of a Tier 1. It is a little confusing, but in essence you can create as many levels as you need, you just need to create a new parent/child relationship for each level downwards.

    This TechNet article might help: https://technet.microsoft.com/en-us/library/dn832068.aspx.

    Hope that helps
    James

  • Shahbaaz Ansari Profile Picture
    6,211 on at
    RE: Relating Site Entity to Account Entity

    Hi James Parsons,

    I am unable to create 1:N relationship between Account and Site. Please suggest.

    Thanks,

    Shahbaaz

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans