Creating many-to-many (M:M) relationship maps

Use the Mapping editor to create a many-to-many relationship map.

To create a many-to-many relationship map, have a join table with foreign-keys that point to two different mapped tables.

  1. Select one of the roles and map it to the proper foreign key that exists in the join table. This creates a mapping.

  2. Add a mapping between the opposite role and the other foreign key in the join table. These two maps together make up the M:M mapping.

 

Parent topic

Updating maps with the Mapping editor