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:

• In model-driven apps, select New Column from the form editor and create a Lookup column. More information: Add, configure, move, or delete columns on a form
• Create a new Lookup column for the related table.More information: Create and edit columns
• Import a solution that contains the definition of the table relationship. More information: Import, update, and export solutions
• Use Power Query to create new tables and fill them with data. More information: Add data to a table in Dataverse by using Power Query.
• A developer can use Metadata services to write a program to create and update table relationships. More information: Table relationship definitions

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