[GENERAL] Deleting Problem

2006-10-30 Thread Jamie Deppeler
Here is my problem I have a level structure which is 5 levels deep with 6 tables, for this example i will call it table1,table2,table3,table4,table5,table6 (1)table1 (2)table2 (3)table3 (4)table4 (5)table5,table6 (6)table7,table8 table5 and table6 have fk keys pointing to

Re: [GENERAL] Deleting Problem

2006-10-30 Thread Stephan Szabo
On Tue, 31 Oct 2006, Jamie Deppeler wrote: Here is my problem I have a level structure which is 5 levels deep with 6 tables, for this example i will call it table1,table2,table3,table4,table5,table6 (1)table1 (2)table2 (3)table3 (4)table4 (5)table5,table6 (6)table7,table8 table5 and

Re: [GENERAL] Deleting Problem

2006-10-30 Thread Reece Hart
On Tue, 2006-10-31 at 10:24 +1100, Jamie Deppeler wrote: Here is my problem i have delete triggers on table5 and table6 which update summary information on table1,table2,table3,table4 if table5 or 6 gets delete, problem i am faced with is when eg table1 record gets deleted