Configuration Guidelines > Performance Guidelines > Multivalue Link Underlying Multivalue Groups >

Indirect Multivalue Links Through Joins

Although the parent business component of a multi-value group (MVG) is usually the same as the business component in which the MVL is defined, this is not always the case. For example, the Opportunity business component, like the Account business component, contains a multi-value group of business addresses. In this case, the business addresses are not directly related to the opportunities themselves; instead, they are children records of whichever account is associated with the current opportunity (if there is such an account). In order to correctly populate this MVG, Siebel eBusiness Applications need to know how to find the appropriate parent account record for this link, given the current record in the Opportunity business component. The SrcField property of the multivalue link object exists for this purpose.

Using the preceding example, the Business Address MVL is defined as follows within the Opportunity business component:

[Multivalue link]

SrcField = Joined Account Id

DestBusComp = Business Address

DestLink = Account/Business Address

PrimaryIdField = Primary Address Id

CheckNoMatch = TRUE

PopupUpdOnly = TRUE

Note that the DestLink of this MVL is still the Account/Business Address link, which defines the one-to-many relationship between accounts and business addresses. So, in this case, the parent business component of the link (that is, Account) is not the same as the business component in which the MVL is defined (that is, Opportunity). To determine the appropriate Account records for which to get the children Business addresses, Siebel eBusiness Applications look at the SrcField property of the MVL. For this particular multi-value link, the SrcField property refers to the Joined Account Id field in the Opportunity business component, which maps to the ROW_ID database column from the joined S_ORG_EXT table. So, for each Opportunity record, Siebel eBusiness Applications will populate the MVG with all Business Address records that are children of whichever account is indicated by the ROW_ID value stored in the Joined Account Id field.


 Configuration Guidelines 
 Published: 18 April 2003