I Have a parent table with worker ID as primary Key, and a set of children rows. Now if I go to a children row detail and change the parent worker ID, it changes the parent for all his brothers too (all the children rows). How could I change the parent for one row only?
Explain or illustrate how you are doing this. Maybe the technique you’re using indeed applies to all children rows rather than only the one you think you’re editing.