Topic: System dialog message
I like to replace the following Error dialog message with custom info dialog. Is it possible, if so how please?
Situation I'm trying to find solution for as follows:
1. I have customer records on customers tGrid.
2. When customer has an sale invoice record (Sale invoice table is linked to customer table, id_Customer), clicking on delete button on customers tGrid returns the above error message after standard delete confirmation dialog. It's fine in respect of database integrity which prevents user having invoice record without a customer, but not a user friendly one. I wanted to replace foreign key constraint error dialog with a friendly info dialog box.
Other solution I thought adding cascade delete on sale invoice table but it doesn't seems an attractive in this case. User may delete a customer by mistake which may cause considerable problem for the user, especially if deleted customer had many invoices etc.
Please see attached sample project. First 3 customer has invoice, clicking on delete for any of those customer with invoice brings the above unfriendly foreign key error dialog
God... please help me become the person my dog thinks I am.