I have three tables in my application called ASSETS, ASSETS_GROUP_MOVS, and ASSETS_GROUP_MOVS_LINES.

The ASSETS_GROUP_MOVS and ASSETS_GROUP_MOVS_LINES tables function as master/detail tables through the [id]/[id_group] fields.

In the ASSETS_GROUP_MOVS_LINES table, there is an [id_asset] field that points to the [ASSETS] table.

The problem is as follows: When a new record is inserted into the ASSETS_GROUP_MOVS_LINES table, I want it to take the value from the [office] field in the parent table, ASSETS_GROUP_MOVS, and update the [office] field in the [ASSETS] table.

Thank you very much for your help.