Jeff,

I haven't coded it myself (hence haven't personally tested it), but I've seen this handled in other folks' code I've worked on by wrapping the delete in a transaction, as Al suggested, and then trapping error 1539 (Trigger Failed), setting a flag and doing a Rollback if necessary.

...Jim