for your FOREIGN KEY relationship, add ON UPDATE CASCADE

if your column is IDNETITY, you got to change it to non-identity.

after that, run an UPDATE function on your main table. your child table will get updated automatically.

when this is done, remember to set the key column to IDNETITY