Delete record not deleting entire record

Delete record not deleting entire record

I'm using an on delete script to delete Child record of a parent record. These records are related by a field called parentID.

delete from stdStyleDesign[ parentID == input.stmID ];

where stmID is the ID of the parent record.

This call results in clearing the parentID "field" of the stdStyleDesign record but NOT deleting the record.

Is this a bug or am I missing something?

regards,

Tim Sadler