There are two new fields in sales header by name product type(option) and test order no.(text). the requirement is test order no. must be updated with the concantenated value of product type+No. ie after i update the product type field, automatically the test order no. field must be updated with the two values of no. and product type. thanks in advance
If I understand, you should use the OnValidate trigger of the “Product Type” field to: IF “Product Type” <> xRec.“Product Type” THEN “Test Order No.” := COPYSTR(FORMAT(“Product Type”,0,’’) + ‘-’ + “No.”,1,MAXSTRLEN(“Test Order No.”)); -john