Announcements
Hi everyone,
I defined a 1:N relation between 2 tables in dataverse. When I'm looking for associated records in the "1" table, I can see them. But when I try to do the same operation in the "N" table, nothing is showing up. I tried to add a subgrid in the form of my "N" table, but the related table does not appear. Where Am I wrong ? Thanks for your help.
Regards
Hi @blaisecorneloup,
That's expected that you won't see the related records from the N side of the relationship, as there is only one record it can be related to. The Lookup field would show the 1 side of the relationship from the N perspective.
---Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Thank you @ChrisPiasecki. How can I get around this ?
You cant get around this, this is out of box behavior with relationships. In the related tab you will only see tables that have a N:1 relationship with the table, not the other way around.
Ok, I'm gonna try to deal with it. 1 last question please, why there is no 1:1 relation ?
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.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
