2 Replies Latest reply on Dec 10, 2010 6:29 AM by smccroy

    Need to display text from allowed values in query


      I have a Change attribute, which has allowed values to fill in a drop down box.  When this was created, it was just for information.  Now, the person that built the window is asking that we build a query allowing users to choose from one of the allowed values.


      The problem now is that when I build the query to prompt the user, it just shows them the value (0,1,2...etc) and not the text the value correlates to.  This does no good to the end users running the query, as they do not know which value relates to which menu item.


      Is there a way for me to display the Text of the allowed value in the query prompt or am I going to have to convert this to an ordered list or a category?


      Thanks for any help.


      Sean McCroy