Using Links to derive 1:M and M:M Relationship

Home >> Siebel Tools >> Links >>

About Links Link Properties

1:M Relationship...

• link object derives one-to-many relationship between two business components
• parent business component's unique reference has been stored as foreign key in child business component

for example

Lets take Order/Order Items view as an example, an Order record can have multiple order line items. Each record in order line item holding a foreign key reference from parent order record. So in application whenever the Order record is displayed, the relevant items are pulled and displayed in Order Items Applet with the help of Order/Order Items Link

M:M Relationship...

• two one-to-many relationship link object definitions with opposite master-detail settings are used to establish a many-to-many relationship
• Unlike one-to-many link, the many-to-many link is not storing any parent business component's reference in child business component (moreover it is not possible to store/derive many-to-many relationship with the help of two tables)
• to store/derive M:M reference, Siebel CRM uses an intersection table and this table creates a new record whenever an association occurs between M:M relationship
• Siebel CRM removes record from intersection table whenever dissociation occurred in M:M relationship

for example

Lets take a relationship between Employee and Responsibility, each employee/user in an organization can have one or more responsibilities to proceed his/her activities in Siebel application, similarly for the same role there can be more than one employee in the organization so it requires the same responsibility to be assigned more than one employee. To satisfy both the scenario, Siebel CRM uses an intersection table and creates a new record whenever a responsibility associates with an employee and vise versa