-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Microsoft Power Platform Solution Architect's Handbook
By :

Relationships between tables provide referential integrity. Dataverse further enhances these relationships with cascade behaviors, controlling what happens when a parent or child record is deleted. This section describes the different types of relationships, cascade behaviors, and the decision process for their selection.
There are two types of table relationships in Dataverse: one-to-many and many-to-many relationships. Let’s take a look:
When a Lookup column is added to a table, it automatically creates a one-to-many relationship (also known as a 1-N relationship). One-to-many relationships are used by Power Platform applications to traverse data hierarchies. As well as maintaining referential integrity, creating one-to-many relationships between tables enables the following capabilities:
Change the font size
Change margin width
Change background colour