Onchange of state field in transfer order table then state and substate populating in asset table

[vinod6]

Hi All,

I have a scenario

In alm_transfer_order_line table  whenever populate the stage is "In transit" and there is a reference field in the same form (field name is "Asset ")    based on the asset ref field (asset ref table name is alm_hardware) table state and substate is  populate respect. Please provide the script. It is help for me. Please see the below one's

Table name:alm_transfer_order_line

Table name:alm_hardware

I need to updated auomatically the state is "In transit" substate is "Reserved.

Please show the example one

I am trying BR but not working .Could you please provide the correct BR script. It's helpful for me

Thanks