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.