Configuring Siebel Business Applications > Configuring Tables > Modifying Shapes and Lines in an Entity Relationship Designer >

Configuring Objects to Use a One-To-Many Extension Table

To use a one-to-many extension table, you must configure the objects that this topic describes.

CAUTION:  Do not use a one-to-many extension table as an extension to a predefined one-to-many extension table. This configuration causes problems with Enterprise Integration Manager and docking processes.

To configure objects to use a one-to-many extension table

1. Create a new business component and new fields in the business component that references columns in the one-to-many extension table that you use to store data.
2. Define the following business component fields:
   1. PAR_ROW_ID. References the foreign key field that the one-to-many link uses.
   2. NAME. Makes the record unique for each parent record.
   3. TYPE. Groups records in the extension table.
      • Set a default value for the Type field.
      • Define the search specification for the business component to search for records in the extension table that contain the default value. For more information, see Options to Filter Data That Siebel CRM Displays In an Applet.

        To satisfy the U1 index of the one-to-many extension table, the combination of NAME, TYPE, and PAR_ROW_ID must be unique.

3. Add a link and business object component that creates the parent-child relationship between the new, child business component and the parent business component.