Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 739 Most Valuable Professional
Michael E. Gernaey 343 Super User 2025 Season 2
Power Platform 1919 268
