Store Value Show Name

[Joel Saltzman]

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.

[origamijason]

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.

[comment]

Use a Pop-up Menu instead of a Drop-down List.

[LaRetta]

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, 2008 by Guest