what is the best way to trace RI code to determine where a trigger is failing? I have cascading delete on most of my children tables and (sometimes) when I delete a record from the master table, I get an error message "trigger failed". I can't figure out why this is happening, and can't set the debugger on to trace the code to find out where this is happening so I can fix it.

Thanks for any help :-)

John.