Hi Jeff,

Thanks for all your help with this. I feel the same way you do with the CASCASE. I think it is the wrong way...

Wait, I didnt think my chains overlapped.

Here:

ZIP>SCHOOL

ZIP>DISTRICT

My district tabel and school table have a reference to zip.

If I delete ZIP I want to delete both the school and district

So each...

Yes, and thats really wired because I trued that, well sort of.

I tried the following:

alter table my_table2

add constraint fk_my_table2

foreign key (fk_id2)

references my_table1(pk_id)

on delete cascade

This worked, then tried this

alter table my_table3

add...

How do you get around Delete Cascade when there are more that 2 tables involved without a trigger? is there a way in 2008?

Thanks

Does 2008 allow this? If not, is there a way around it without a trigger? Like DeleteOnNull or something like that? I'm trying to convert my oracle...