The Data Modeling Workspace › Logical and Physical Modeling › How to Resolve Many-to-Many Relationships

How to Resolve Many-to-Many Relationships

You can resolve many-to-many relationships in both logical and physical models:

• Right-click a relationship on the diagram window.
• Select the Create Association Entity option from the Relationship shortcut menu if you are in the logical model; select Create Association Table if you are in the physical model.
• Set options for resolving the many-to-many relationship in the Many-to-Many Transform Wizard that opens.

More information:

Use a Transform to Resolve a Many-to-Many Relationship