Is it possible to have a different display value from the actual value of the field ? I would like to have a choice field with category codes and the actual category but only the code must show up once selected. e.g. Field Choice = 004 - Blue <--- once selected only 004 shows up in results.
I am no developer but i am busy with concatenate and not getting it right. Is this possible outside of too much programming ?
Thank you in advanced