AnsweredAssumed Answered

Pulling a value from a ValueList based on another field.

Question asked by Matty_1 on Aug 11, 2011
Latest reply on Aug 11, 2011 by Matty_1

Title

Pulling a value from a ValueList based on another field.

Post

Hello,

 

I have a field called Grade and a field called Grain, I also have a value list called Commodities.  The value list resembles the following:

100 WHEAT

102 WHEAT HVY

200 OATS

202 OATS HVY

300 BARLEY

ETC.

What I would like to have is a calculation field that refers to the Grade.  Based on the grade it will search the value list for the corresponding value so if the Grade is 100 then I would like Grain to be "100 WHEAT"

 

Thank you.

Outcomes