>>>>>>What is the correct syntax? TIA
>>>>>
>>>>>I don't think there is a way.
>>>>
>>>>Do think that in this case instead of setting ON DELET in foreign key constraint I need to do it in Trigger?
>>>
>>>Yes, with the trigger you can do this.
>>
>>Thank you. Do you think it is a step back in using trigger for cascading and updating instead of using foreign key constraint?
>
>Well, using FK constraint is the simplest thing to do, but if it doesn't work the way we need, triggers are the second logical step.
Thank you. Time to start learning triggers.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham