Creating an Association Between One Parent and Multiple Child Records

If you create a link and an intersection table that creates a many-to-many relationship between a parent business component and a child business component, then Siebel CRM can only associate two business component records at one time even if the unique keys in the intersection table allow multiple associations. The link between the two business components only considers the ROW_ID values of the parent and child records that Siebel CRM requires to maintain the many-to-many relationship. This behavior is expected.

An intersection business component is a type of business component that references an intersection table and a one-to-many link between the parent business component and the intersection business component. You can use it to create multiple associations between one parent and multiple child records. The child list applet or multi-value group applet references the intersection business component. To choose the child record, the user accesses a pick applet that references the child business component instead of using an association applet.

For more information, see How an Intersection Table Defines a Many-To-Many Relationship.

To create an association between one parent and multiple child records

1. In Siebel Tools, in the Object Explorer, click Business Component.

2. In the Business Components list, query the Name property for Account.

   This example describes how to configure an intersection business component with the Account business component.

3. In the Object Explorer, expand the Business Component tree, and then click Field.

4. In the Fields list, add a new field using values from the following table.

   Property	Value
   Name	Add any value.
   Column	ACCNT_NAME This property must reference a denormalized column that resides in the intersection business component.
   Pre Default Value	Parent: 'Account.Name'

   For more information about how Siebel CRM uses this configuration, see How Siebel CRM Uses Denormalized Columns.