Deleting a record is not possible when the record is linked in other tables (unless ‘cascade delete’ is set). The GUI will show the following error message when this situation occurs.
The error message doesn’t clearly mention which records are causing this problem. A user would like to see the specific records that are linked to the row. This error could occur in a lot of screens when ‘cascade delete’ is OFF.
A solution would be to create specific errors per table. But this would result in a lot of INSTEAD OF DELETE triggers and a lot of (TSF) messages.
I’d rather see the GUI solving this issue with the knowledge of the metamodel behind it and showing every entity with the look-up value of conflicting records.