To create a new many-to-many relationship, you edit your solution, select the entity, click on the Relationships tab, click on + New relationship, and, from the drop-down list, select Many-to-many, as shown in Figure 3.11. A pane will open where you can select the other entity for the relationship.
When you create a many-to-many relationship, a hidden intersect entity is created to hold the data for the relationship.
Many-to-many relationships suffer from some important limitations:
- You cannot describe the relationship by adding fields.
- Classic workflow and Power Automate flows cannot be triggered when records are associated.
Instead of creating a many-to-many relationship, you should consider either of the following options:
- Creating a custom entity with two many-to-one relationships
- Using connections