Configuring Two Links That Create a Many-to-Many Relationship

Siebel CRM uses two links with opposite parent-child settings to create a many-to-many relationship that reference an intersection table. The Opportunity/Account link is an example of this type of link, where:

  • The intersection table is S_OPTY_ORG.

  • The Inter Child Column is OU_ID, which is the ID in the Account business component.

  • The Inter Parent Column is OPTY_ID, which is the ID in the Opportunity business component.

For more information, see How an Intersection Table Defines a Many-To-Many Relationship.

To configure two links that create a many-to-many relationship

  • Set the Inter Table, Inter Parent Column, and Inter Child Column properties of the two links to create the connection between the links and the intersection table.