Table relationships overview

Table relationships define the ways that table rows can be associated with rows from other tables or the same table. There are two types of table relationships.

  • One-to-many relationships. In a one-to-many table relationship, many referencing (related) table rows can be associated with a single referenced (primary) table row. The referenced table row is sometimes referred to as the ”parent” and rows of the referencing table are referred to as ”children.” A many-to-one relationship is just the child perspective of a one-to-many relationship.
  • Many-to-many relationships. In a many-to-many table relationship many table rows can be associated with many other table rows. Rows related using a many-to-many relationship can be considered peers and the relationship is reciprocal.

See also

Create a relationship between tables
Create Many-to-many table relationships in Microsoft Dataverse using Power Apps portal