Skip to Content
0
Former Member
Apr 10, 2016 at 11:19 PM

Picking one type of multi record

22 Views

HI I Have data like this:

Order# Order_code Order_Amt

123 Code1 100.00

123 Code2 100.00

123 Code3 100.00

123. Code4 100.00

Most of our orders will have only one order_code per order, but some have more than 1.Different parts require different works etc..

So in the above suppose we have a hierarchy, if there is a code1, only show that. if not a code1 in this list, then code2 is next.

How do I code this in the record select?