>I am working with a legacy app that shows a "Trigger Failed" message when deleting a record from a table. Is there a way to replace this message with a better message like "Cannot delete this Team because it is being used by the Projects Table".??

Yep, when you get an error 1539 in you error handler, you know that the trigger failed, so instead of doing your default error behavior, show your message like you want.