Change the parent of a row

[Nicolas_Cabello]

Hi

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?

[Nicolas_Cabello · Accepted solution]

Solved, I am not sure if it was an error or not, but I enabled "is part of?" in the children reference and now it works fine  

[dbaum]

---

@Nicolas_Cabello wrote:

if I go to a children row detail and change the parent worker ID

---

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.