If ppp_req_tbl_approval is your subform, then it cannot be resolved this way. #form.tablename.field# reads the data from the parent form. 

If I'm not mistaken,  to read data from another form to populate the parent form, you need to use something like this:

#form.subform.field[{mainform.recordId}]#  OR

#binder.SUBFORM_DEF_ID.FIELD_ID[PRIMARY_KEY]#

Hash Variable#FormDataHashVariable

Hope this helps. 

Hi Voon Lok, Thanks much for your quick answer but I am not certain how to obtain the 'recordid' or 'primary key' for the current main record and secondary record as this is during a workflow process and they are not known ahead of time.

Yea, that could be challenging. Maybe you could use a Database Update Tool before or after the Form Update tool?

Hi, Voon Lok is right. You can use the follow for main form primary key #form.main_form_table.id# and use this for subform #form.subform_table.field[{form.main_form_table.id}]#.

Thanks. Got it solved using Database Update Tool from the Map Tools to Plugins with this query below. Now the main flow record shows the correct status for the sub flow record. :-) UPDATE app_fd_ppp_req_tbl LEFT JOIN app_fd_ppp_req_tbl_approval ON app_fd_ppp_req_tbl.id = app_fd_ppp_req_tbl_approval.c_parent_id and app_fd_ppp_req_tbl_approval.c_review_approval_type = 'field-review' SET c_field_review_status = app_fd_ppp_req_tbl_approval.c_status

Thanks, I will try that also. Database Update Tool works for sure.

awesome!