I think i am missing something here...
we have a table A and that has one to many relationship with B.
ie an A corresponds to many B.
if we happen to delete a record from B, it deletes the parent from A.
That means the other records in B dont have a parent, ie, the foreign key is violated.
I dont think that is possible, is it?
Seriously Rick? Seriously? You might as well just read this tiny ad:
Devious Experiments for a Truly Passive Greenhouse!