Get the lowest status for a group of sales orders

Hi everyone,

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.
For example:
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 :mrgreen:

Hi Poppins,

Yes, that’s possible. How are you defining the group of Sales Header records that you want to apply this inquiry to, and are the elements of that group definition present as fields in your target table? Does this field in your specific table need to be a flowfield?