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

  1. Click the magic wand icon in the Web Tools toolbar.

  2. Click MVG.

  3. Provide a unique name for the MVG.

  4. Choose a Project.

  5. Choose the parent Business Component where the MVG will reside.

  6. Choose the detail Business Component from which the records will originate.

  7. Click Next.

  8. 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.
  9. Click Next.

  10. Choose the field in the parent Business Component that will hold the pointer to the primary detail record as the Primary ID Field.

  11. Determine how the primary record should be handled by selecting either the Default, Selected or None radio button.

    1. Default: The first record becomes the primary.

    2. Selected: If the user views the multi-value group applet, and then exits, then the highlighted record becomes the primary.

    3. None: The user must use the pick map to include the Primary Owner Id manually.

  12. 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 to FALSE, then Siebel CRM queries the child table each time it modifies a parent.

  13. Optional: Select the Check No Match check box. When Check No Match is set to TRUE, 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.
  14. Click Next.

  15. Choose the options for the Multi-value Link.

  16. 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.

  17. Click Next to get a summary of your choices.

  18. Click Finish.