Hi,
I have a table DEPTT and STAFF .In DEPTT there is a primary key D_ID which is foreign key in STAFF.Changes made in DEPTT table for D_ID results in
."violated - child record" error.This is working correctly.However
when I change D_ID in STAFF the record gets updated and no error is thrown.
My understanding is that it should reflect back in the main parent table (DEPTT) also.

Please let me know if I am thinking right.
Thanks in advance,
dhawanmansi