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

This table describes some objects that Siebel CRM uses to create an indirect multi-value link (MVL) that involves the Business Address in the Contact business component. The Contact business component and the Account business component each contain the Business Address MVL.

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 MVL 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 MVL 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 MVL is typically the same as the business component that contains the MVL. You can use the Source Field property of the link to create a MVL whose parent business component is related to the current business component indirectly through a join or another MVL.

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 MVL is the same as the parent business component of the underlying link that the MVL references.

For example, the following table lists some properties that Siebel CRM defines for the Business Address MVL 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 MVL references the Account/Business Address link. The following table lists some 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 MVL 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's currently chosen in the Account business component.