Drop down list with a different output than input

[cburke996]

Hi all - I am wondering if there is a way to create a dropdown list that outputs a different value than what the input was.

For example, I want the dropdown list to contain full words (Machined, Bought, Assembled ect...) and when you click those words, it outputs a code based on the word (M, B, A ect...). Can I do this?

Thanks,
Connor

 

[BrianMH]

Yes. Make it a multicolumn drop down bound to the first column. Make the first column width = 0 so it doesn't show. Now only the second column will show but the output will be that of the bound column.