"To start with I'm a newbie so detailed help is appreciated.
I have a Material field that is text multiple choice with selectable values DFM or DFR etc. I have a Cost field that is numeric formula that I would like to have a value associated with what is selected from the material field.
So if DFM is selected in the Material field the value in the Cost field would be $100 or if DFR is selceted the value would be $120. ?