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.