Hi,

Given four tables:

Lists
Fields : ID

Columns
Fields : ID, ListId

Rows
Fields : ID, ListId

RowColumns
Fields: ID,RowId,ColumnId

If a row in the Lists table is deleted then I want to cascade the delete to both the Columns and Rows tables.
If a row in the Columns or Rows table is deleted then I want to cascade the delete to relevant rows in the RowColumns table.

If I try to set this up using relationships I can cascade the delete to RowColumns from either the Columns or the Rows table but not both - that causes a 'multiple cascade path error'. How can I achieve the desired behaviour ?

Regards,
Viv