
So, I have made a custom table Capital request which has a header part and line part. I have the common field 'Status' in the line part and header part. When I post the order, the status of the capital request line is updated into partially ordered status. Now, I have to update the Status in the header part.
Hi Sujan,
You can achieve the requirement using the below methods.
You can subscribe to OnAfterValidateEvent of your Status field at your line that will update the header using the primary key once there are changes/validations.
Here are the links for usage
Change the FieldClass of your Status field at the header to FlowField then declare the CalcFormula that will lookup for the value of your status field at your line.