create-edit-1n-relationships.md

title	Create 1:N (one-to-many) or N:1 (many-to-one) table relationships in Power Apps overview
description	Learn how to create one-to-many or many-to-one table relationships in Microsoft Dataverse
ms.custom
ms.date	09/18/2024
ms.reviewer
ms.suite
ms.tgt_pltfrm
ms.topic	overview
applies_to	Dynamics 365 (online) Dynamics 365 Version 9.x powerapps
author	Mattp123
ms.assetid	52c00707-b2bc-4950-abec-89baefd94f6e
caps.latest.revision	33
ms.subservice	dataverse-maker
ms.author	matp
tags
search.audienceType	maker

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:

[!VIDEO https://learn-video.azurefd.net/vod/player?id=19b21a48-4a49-4163-8506-7fb79f3290ef]

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

[!INCLUDEfooter-include]