Hi,

simpe relation A->B (1->M)

I put an fkey constraint on fkey in table B because I do not want any records entered in B that do not match up with key in A ... great it works.

Now ... I want to BE ABLE TO DELETE a row from A and have it cascade to delete related rows in B ... I write it as a trigger in A and it works too ... but only if I don't have the fkey constraint in B! Otherwise, I never get to the trigger because of FKEy violation error.

How can I get my cake and eat it too here? It's like I really only want "one side" of the fkey cosntraint.

TIA,
Ken