Dataverse self-lookup column

[apangeles]

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. 

[Fubar · Accepted solution]

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

[apangeles]

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. 

[Fubar]

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]

Hi @Fubar, 

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