Using the Multi Value Group Wizard in Web Tools
Web Tools provides a wizard to create a new MVG. You must have an editable Workspace open in Web Tools to create a new MVG.
To create a new MVG using the wizard
-
Click the magic wand icon in the Web Tools toolbar.
-
Click MVG.
-
Provide a unique name for the MVG.
-
Choose a Project.
-
Choose the parent Business Component where the MVG will reside.
-
Choose the detail Business Component from which the records will originate.
-
Click Next.
-
Choose the Link between the parent and detail Business Components.Note: Although there may be more than one Link shown, you may only choose one.
-
Click Next.
-
Choose the field in the parent Business Component that will hold the pointer to the primary detail record as the
Primary ID Field
. -
Determine how the primary record should be handled by selecting either the
Default
,Selected
orNone
radio button.-
Default: The first record becomes the primary.
-
Selected: If the user views the multi-value group applet, and then exits, then the highlighted record becomes the primary.
-
None: The user must use the pick map to include the Primary Owner Id manually.
-
-
Optional: Select the Use Primary Join check box. It is a recommended to use a primary join for improved performance. The
Use Primary Join
property of a multi-value link enables the primary join feature.If you set Use Primary Join to
TRUE
, then Siebel CRM gets the primary child record for each parent record through a join with the Primary ID Field. If you set Use Primary Join toFALSE
, then Siebel CRM queries the child table each time it modifies a parent. -
Optional: Select the Check No Match check box. When
Check No Match
is set toTRUE
, a separate SQL query is executed for each parent record in which the primary join did not find a primary child record.Doing this ensures that the multi-value field does not appear blank unless there are no child records. But executing these extra SQL queries decreases performance.Note: The default is False. -
Click Next.
-
Choose the options for the Multi-value Link.
-
Choose which Fields you wish to create in the parent Business Component. If the Fields you choose already exist in the parent Business Component you cannot add them again.
-
Click Next to get a summary of your choices.
-
Click Finish.