I've set up my application where I have Contacts and Orders

On the Contact form, I've added the Orders as a Sub-Form.  So from the Contact edit page, I can add Orders.

On the Order form, I've added a look-up field back to the Contact.

Essentially, what I've done is created a two-way relationship where I can view the Order Details from the Contact and I can view the Contact information from the Order.  The built in bi-directional relationship wasn't what I was looking for.

The problem that I'm seeing now is when I delete an Order from the Contact Sub-Form.  When this action is performed, the Order is removed from the Contact, but the Order record still exists and it will still point to the Contact record.

I assume this is because when you remove the Order from the Contact, the relationship from the Contact to the Order is removed but the Order record still has something pointing back to the Contact.  I'd actually like to have this Order record deleted rather than severing the relationship.

I've tried adding scripts to the following forms with no success: 

1. Order-On Edit-Success 

2. Contacts-On Edit-Validate

3. Contacts-On Edit-Success

Any ideas how this should be done?