Update Radio Button using workflow based on lookup field
I have a field that I use to determine the status of a customer order. The three selections are:
"HEDGE" (If I'm putting an order into my system based on historic order patterns but not an actual order from the customer (i.e. a blank in the [Customer Order No.] field)
"PLANNING" (If [Customer Order No.] is not blank)
"FIRM" (If there is a value in a related form (based on common [Customer Order No.])