I have a situation that gets me crazy.
I have standard Patent SQL table (isidentity ON) and related Child sql table - set relation On Delete: Restrict.
So I have standard Form for Parent table with a child record on it. When I Insert parent record it creates new ID so that can be used to insert Childs on the same form.
The problem is if I click Cancel it asks me a standard confirmation message like ‘Are you sure you want to cancel?’ (and I want to be asked), I say Yes and got Referential Integrity Delete Error like ‘This record is referenced from the file %File. This record cannot be deleted while these references exist.’ that is also correct.
BUT I need to get rid of the second message and delete related child records silently by myself.
How to achieve this, please? ABC, c10