I have two tables; my parent table named ext and a child named ext2.

ext contains the field “position” which in turn ext2 inherits it in it’s field.

I used on edit cascade and it works fine as it’s what my program requires

here’s what I done when implementing it

FOREIGN KEY (position) REFERENCES ext(position) ON UPDATE CASCADE

It works when I update my parent, it inherits the position field. But, the problem is I want to update the child position again in that table,

if i possibly do that, will the parent also change?