Referential integrity in parent / child relationship
I have a parent / child relationship and I want to warn the user if they try to delete a parent record while there are child records existing. I understand that I can automatically delete the child records by checking the appropriate box in the relationship diagram but what I want to do is to give a warning that this is going to be done or to force the user to individually delete the child record so they are absolutely aware of what they are doing.
Is this possible through the "normal" validation or do specific scripts need to be written to check for these relationships at the time of attempted deletion of the parent.
Help would be appreciated. Thanks.