I have added a custom field “StatusX” in table 36 of type option (op1,op2,op3)
In another specific table, I need to create a field that determines the lowest status for a given group of sales orders.
If I have order A with StatusX=op3, order b with StatusX=op1 and order C with StatusX=op2, I should get op1 in my field.
Is that possible?
Thanks in advance