trigger to cascade delete

I have 3 tables, I will name them 1, 2, and 3.

Tables 1 and 2 both have one to many relationships with table 3.

This makes it impossible to use a foreign key constraint with 'cascade on delete'. The only way I can see doing it is to set up delete triggers on 1 and 2 that would delete the coresponding records from 3. For the life of me, I am unable to get these triggers to work.

Does anyone have some trigger source that does something similar that I could look at?

Thanks.

-Todd

[Quoted] [Quoted] -------------------==== Posted via Deja News ====-----------------------

      http://www.dejanews.com/ Search, Read, Post to Usenet Received on Fri Aug 01 1997 - 00:00:00 CEST