>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

Gary,

It sounds like you should create a delete tigger on the parent which checks the see if the delete of the parent should be allowed, if not, rollback the transaction, if it is allowed continue and the children should be deleted.

BOb