I was wondering if you might have heard this before. I am performing
a dual post on my InfoPath form

1) SharePoint
2) Web Service to SQL DB Relational Database for SQL Reporting

The Web Service is used because of the complex InfoPath form with
repeating items and also the need for some robust reporting. The
INSERT and UPDATE for the form works great. However, I have a real
problem if the InfoPath form is deleted from the Forms Library. My
data in the Database will not be deleted because end user is actually
not in InfoPath to delete the form, but rather in SharePoint. Do you
know of a way or have resources that can help in know how to ensure
the DB record will be deleted from the SharePoint delete?

The DB will use cascade delete to delete 15 tables worth of data. If
a simple DELETE FROM SummaryTABLE WHERE SumID = ???

However, I have to have some way to trigger that Stored Proc and pass
the SumID.