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
User | Count |
---|---|
40 | |
35 | |
30 | |
23 | |
17 |