January 1, 200818 yr I have an ORDERSTATUS field that stores the numbers realted to the names: 1 - Open 2 - Pending 3 - Closed Is there a way to store the number and display the NAME of the status in the field instead of the value? I have overlayed a non-enterable field over it to show the related name but was hoping there is a better way.
January 3, 200818 yr Newbies Perhaps this is a bit big hammer, but you could store the words in the field and use the choose() function to pull numeric values from the list of text values. Alternatively, you may wish to revisit why they need to be numeric at all.
January 3, 200818 yr I can't imagine that you have a related table just to hold these three values? It sounds more like you have a custom value list holding only the three numbers. If you are needing to overlay the number (put the name on TOP) of the number then do you mean the display is as a checkbox or radio button and you're placing text over the numbers? I didn't feel that, when you said 'related' you really meant related but more 'associated'... Edited January 3, 200818 yr by Guest
Create an account or sign in to comment