This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How do you create many-to-many relationships between Dataverse tables?
Create a column of the type Lookup in the one side table.
Create a column of the type Lookup in the many side table.
Create a column of the type Lookup in the one and many side tables.
Select the two tables that you want to create the relationship for in the relationship's menu of the tables.
How do you create a one-to-many relationship between tables?
Define choices for the related table as a choice column.
Select the one-to-many option when selecting column type.
Create a new column with the column type of Lookup to the related table
Create a multi-line text column detailing the relationship.
Is the many-to-one relationship the child perspective of a one-to-many relationship?
Yes. A many-to-one relationship is the child perspective of a one-to-many relationship.
No. A many-to-one relationship isn't the child perspective of a one-to-many relationship.
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?