change value in multiple rows

Dears

How can we change the foreign key from value to other value in one step , example like change the student classroom to other class - like two combo box one for the original and the other for the one we want to replace to .