Setting the Cascade Delete Property of a Link

The Cascade Delete property of a link specifies the action that Siebel CRM performs on detail business component records of the link if Siebel CRM deletes the master. You can use one of the following values:

• CLEAR. Siebel CRM removes the foreign key reference.

• DELETE. Siebel CRM deletes the child record.

• NONE. Siebel CRM performs no operations on the child record.

You must set the Cascade Delete property to CLEAR in the following situations:

• The child business component in this link is also a child business component in another link.

• Another business component references the same table that a child business component references, and this other business component is the child business component in another link. For example, assume the following links exist:

  • Contact/Action

  • Contact/Activity Plan

Action and Activity Plan reference the same table. You must make sure Cascade Delete is CLEAR for each link.

Do not set the Cascade Delete property to NONE for a many-to-many link. Siebel CRM deletes the intersection record for a many-to-many link but does not delete the child record. This child record might have other parents.

If multiple links exist that reference the same tables, then you must make sure that you set the Cascade Delete property consistently among all of these links. If Siebel CRM deletes a record that is a foreign key of another table, then it might or might not delete these references. If it does not delete these references, then row IDs might reference nonexistent records. Siebel CRM might convert these foreign keys to No Match Row Id for a multivalue group.