Create one-to-many or many-to-one table relationships in Microsoft Dataverse overview

In Microsoft Dataverse a one-to-many (1:N) or many-to-one (N:1) relationship defines how two tables are related to each other.

Before you create a custom table relationship, evaluate whether using an existing table relationship would meet your requirements. More information: Create new metadata or use existing metadata?

Watch this video for a quick overview about how to create a table, a table relationship, and columns:

You create and edit table relationships, including one-to-many and many-to-one relationships, in Power Apps.

You can also create new table relationship in your environment using any of the following experiences:

Information in this article helps you choose which designer you can use.

Create a one-to-many or many-to-one relationship

Create and edit one-to-many or many-to-one table relationships in Power Apps

Community tools

table Relation Diagram Creator is a tool that XrmToolbox community developed for Dataverse. Please see the Developer tools for Dataverse topic for more community developed tools.

Note

The community tools are not a product of Microsoft and does not extend support to the community tools. If you have questions pertaining to the tool, please contact the publisher. More Information: XrmToolBox.

See also

Create and edit relationships between tables

Create and edit 1:N (one-to-many) or N:1 (many-to-one) table relationships using solution explorer
Developer documentation: Customize table relationship metadata
Developer documentation: table relationship eligibility