Announcements
Is it necessary to create a relationship 1:N and N:1 on both the Parent and Child tables, respectively? What is the effect or benefit this will have?
@w1sd0m
It depends on what you are trying to achieve, typically 1:N and N:1 between 2 entities simply means 1:1 relationship.
Hi @w1sd0m ,
When you add the lookup field to the child entity related to the Parent entity Dataverse will automatically create the 1:N and N:1 relationships respectively. You don't need to create these manually.
Hi @w1sd0m
Did this solve your issue here?
Hi,
I have two excel tables, in the first one I record employee data, in the second I record employees manager data. In the first one I have a column with the identier of the manager. I want to relate both tables so in the gallery I get the name of the manager instead of the idetifier of the manager. How I can do that?
Hi @yamaing ,
Can you please create a new issue / question vs. adding on to an already solved one? This way you will be able to mark the answer verified and it won't have two different items combined.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 93 Most Valuable Professional
Haque 81
Valantis 49
