Interesting issue.

I have a template with a delete option for each record.. when I click delete it calls an sp. When the sp runs it verifies the records id is not in another file (assigned to something) and it either deletes or doesn't.

The strange part:

When I click delete and the record is not removed from the list, if I leave that browser window and go to another window where I delete the child record (the one that is causing the sp not to delete), and I go back to the browser window and refresh it - the item successfully deletes and is removed from the list. I never click 'Delete' a second time.

Woh.