Subject Re: Constraints - Cascade Delete from multiple parent tables
Author Bhavbhuti Nathwani
Hi Alan

--- In, "Alan McDonald" <alan@...> wrote:
> you cannot use the system FK constraint mechanism for this setup.
You cannot
> have a "multi-homed" foreign key. You can, however, use before delete
> triggers on the parent table to delete records in your transaction
> The only other way to use system cascading deletes in this situation
is to
> have separate transaction tables for each parent. You can always
union the
> tables to gether if you want result sets which combing them.

Happy New Year!!!

Thanks for your response. I took your advise and created a Trigger
and I have the required results.