AnsweredAssumed Answered

numeric value in table but text label in form

Question asked by AlbertPujol on Nov 8, 2011
Latest reply on Nov 14, 2011 by AlbertPujol

Title

numeric value in table but text label in form

Post

 Hello everyone,

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.

Outcomes