|Subject||Re: Constraints - Cascade Delete from multiple parent tables|
--- In email@example.com, "Alan McDonald" <alan@...> wrote:
> you cannot use the system FK constraint mechanism for this setup.
> 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
> have separate transaction tables for each parent. You can always
> 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.