Update field from Orderdtl to Jobhead

Kinetic ERP
,
1

Hi All,
I need to update JobHead.CheckBox02 when OrderDtl.Checkbox02 is set to true.
how can this be done?
Thanks.

2

Use a data directive and a condition to find when checkbox2 is changed, make the same change to jobhead using getdatasetfortree, update table by query, and update. You could probably also do this in a function if you don’t want to get into data directives.

The main problem I see is that OrderDtl doesn’t have checkbox fields, so you must have added them as custom fields ahead of time.
Good luck!

2 Likes
3

thanks @NateS I have already added the checkbox field in orderdtl.
I’ll try this approach.

4

The Job number is also on the release line. So you need to take that into account also, unless you have a custom job number field on the OrderDtl.