Hi all,
I'm trying to handle a cascading delete based on values in the child table. In other words, I want the delete to cascade if a user hasn't entered a value in a certain field of the child else disallow the delete of the parent record. Any suggestions on the best way to accomplish this? I tried to set up a delete restrict if a child record exists and then put code in the parent checking the child condition and deleting the child records if it's OK. Didn't work, I assume the trigger fires too late. Thanks.

Gary Foster