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

[Sistemas_Ammade]

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

[LeventK]

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

[Sistemas_Ammade]

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

[LeventK]

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

[Sistemas_Ammade]

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

Thanks