Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
Answered

Dataverse self-lookup column

(0) ShareShare
ReportReport
Posted on by 234

Hi everyone, 

 

Just for curiosity, in what situations do I need to make a column with a lookup column type that connects to the same table? 

 

Thank you. 

Categories:
  • apangeles Profile Picture
    234 on at
    Re: Dataverse self-lookup column

    Hi @Fubar

     

    Thank you for your answers! I very much appreciate your time.

  • Fubar Profile Picture
    7,960 Super User 2025 Season 1 on at
    Re: Dataverse self-lookup column

    Yes, a Contact can be associated with many Accounts - however, out-of-the-box this relationship is not present (you would have to create it, a one-to-many between Contact to Account or a many-to-many between them) 

  • apangeles Profile Picture
    234 on at
    Re: Dataverse self-lookup column

    Hi @Fubar 

     

    Thank you. In relation to this, I think, what if a contact has multiple accounts related to it? Can it be possible? 

     

    Because you've mentioned the bill of materials case, I assume a single product/material can be associated with multiple products, can a single contact be associated with multiple accounts? 

     

    Thank you. 

  • Verified answer
    Fubar Profile Picture
    7,960 Super User 2025 Season 1 on at
    Re: Dataverse self-lookup column

    Could be many situations depending on your needs.  The classic example in data modelling is what is called a Bill of Materials (basically a Product that is made up of other Products each of which could be made up of other products etc etc), in Dynamics 365 there is one for Accounts with Child Accounts e..g. a Head Office account and it has Regional Offices.

    Similarly an Organiszation hierarchy, Management/Position hierarchy, would be other examples

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >