Picking one type of multi record
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?