Configuring Siebel eBusiness Applications > Configuring Links >

Using Two Links to Define a M:M Relationships

Two link object definitions with opposite master-detail settings are used to establish a many-to-many relationship based on an intersection table. The Inter Table, Inter Parent Column, and Inter Child Column properties of the two Link object definitions are used to establish the connection between the links and the intersection table. An example of this type of link is the Opportunity/Account. 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 information on the use of M:M links, see About Intersection Tables.