numeric value in table but text label in form
I'm trying by all means to create a field that stores a number in the table, but always shows an assigned text label when in form view. I've tried look up values and list values and the nearer I can get to it is that when I introduce the data, the label is shown but when selected the value it turns to the numeric value which will be stored in the table.
I come from access school and I did that with table look up, hiding the first column, and only seeing the second in the form.
Thnks for the help.