Example of How Siebel CRM Creates an Indirect Multi-Value Link

The following table describes some of the objects that uses to create an indirect multi-value link that involves the Business Address in the Contact business component. The Contact business component and the Account business component each contain the Business Address multi-value link.

Object Name of Object Definition

Joined Business Component

Contact

Multi Value Link

Business Address

Joined Field

Joined Account Id

Join

S_ORG_EXT

Join Specification

Account Id

Foreign Key Field

Account Id

Base Table

S_ORG_EXT

Child Business Component

Business Address

Link

Account Address

Parent Business Component

Account

How Siebel CRM Uses the Source Field Property

If the Source Field property in a multi-value link is empty, then Siebel CRM uses the Id field in the current business component. This field corresponds to the ROW_ID in the base table. In the indirect multi-value link for the Contact business component, the Source Field property specifies the Joined Account ID field that resides in the S_ORG_EXT table. The Joined Account ID field provides the Account Id of the Account that corresponds to the current Contact.

The parent business component of a multi-value link is typically the same as the business component that contains the multi-value link. You can use the Source Field property of the link to create a multi-value link whose parent business component is related to the current business component indirectly through a join or another multi-value link.

How a Multi-Value Link References a Link

A link defines a one-to-many relationship between two business components. Typically, the business component that contains the multi-value link is the same as the parent business component of the underlying link that the multi-value link references.

For example, the following table lists some of the properties that Siebel CRM defines for the Business Address multi-value link in the Account business component.

Property Value

Destination Business Component

Business Address

Destination Link

Account/Business Address

Primary Id Field

Primary Address Id

Check No Match

TRUE

Popup Update Only

TRUE

The Destination Link property indicates that this multi-value link references the Account/Business Address link. The following table lists some of the properties that Siebel CRM defines for the Account/Business Address link.

Property Value

Name

Account/Business Address

Parent Business Component

Account

Child Business Component

Business Address

Destination Field

Account Id

Cascade Delete

Delete

The parent business component of the Account/Business Address link is the Account business component. The multi-value link resides in the Account business component. To update the multi-value group applet, Siebel CRM uses data from the children business address records for the account record that is currently chosen in the Account business component.