Establishing table relationships and cascade behaviors

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.

Types of Dataverse relationships

There are two types of table relationships in Dataverse: one-to-many and many-to-many relationships. Let’s take a look:

• One-to-many relationships:

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:

• Users can navigate to a related record within...