Change some column's values in one table, to all the children from the form just added

Hi, I have 3 tables “Productos”, “Movimientos” y “Detalle Movimientos”. I would like to update some column values in “Productos” table: “Date” “Area” and “Ubicación” to all the productos captured in the “Movimientos Form” (The info to update is in the “Movimientos” table wich is parent from “Detalle Movimientos” Is it possible?

Thanks

In what way or how do you want to update the child records? Please elaborate

Hi LeventK:
In the “Movimientos” form I select the “Área”, “Ubicación” and “Resguardante” fields (Image 3) and select “Productos” for the “Detalle Movimientos Table” (second Image). Then when I a save the form, I would like to update the “Área”, “Ubicación” and “Resguardante” columns in the table “Productos” (1st. image) for each product selected in the form.

Thanks

@Sistemas_Ammadeus
From your explanation, I do understand that Productos table is a reverse ref to Movimientos table, am I correct?

Yes, and I want to update 3 column value for the products in “Detalle Movimiento” to the values in “Movimientos” table.

Thanks