Configuring Siebel Business Applications > Configuring Business Components, Links, and Business Objects > Configuring a Link >

Configuring a Link That Deletes Child Records If the User Deletes the Parent Record

The Cascade Delete property of a link determines if Siebel CRM deletes a child record if the user deletes the parent record.

To configure a link that deletes child records if the user deletes the parent record

• Set the Cascade Delete property on the link using values in the following table.

  Value	Description
  Delete	If the user deletes the parent record, then Siebel CRM deletes all child records. Use Delete to delete values that Siebel CRM stores in a one-to-many extension table where the only related record is the parent record. Do not use Delete if the child business component in this link is a child business component in another link. In this situation, use CLEAR instead.
  Clear	If Siebel CRM deletes the parent record, then it removes the foreign key reference and clears the value in the foreign key column. Use this setting if Siebel CRM might share a child record with another parent.
  None	If Siebel CRM deletes the parent record, then it does not delete any records and does not clear the foreign key column. The default setting is None.

Guidelines for Using Cascade Delete

CAUTION:  Be careful. If set incorrectly, the Cascade Delete property might cause data integrity problems or orphaned records.

If you use the Cascade Delete property, then use the following guidelines:

• Cascade Delete is not available for a many-to-many link. A child might be the child of more than one parent when Siebel CRM uses a many-to-many link, so Siebel CRM deletes the intersection record but leaves the child record intact.
• If you delete a record that a foreign key of another table references, then Siebel CRM might or might not delete the reference to the record. If it does not delete the reference, then row IDs might reference records that do not exist. If used with a multi-value group, then Siebel CRM might convert the foreign key to display No Match Row Id.
• The link applies to parent child relationships. Siebel CRM treats a one-to-one extension table as an extension of the parent, so it keeps the extension table synchronized with the parent.
• Use a link except for a one to many extension table that involves two different business components.
• To involve grandchild records, use the Deep Delete business component user property. For more information, see Siebel Developer's Reference.