AnsweredAssumed Answered

Sorting a value list

Question asked by mmccarty on May 8, 2009
Latest reply on May 11, 2009 by LaRetta_1

Title

Sorting a value list

Post

Hello,

  I'm not sure if this is possible but thought that I would ask. I have a value list that show all the possible status types for a product.  The table this pulls from has a status ID from 1-15.  I want the value list to show all the status type in order of their ID's but I don't want the IDs included in the value list.  I can make it display in order like this:

1 Not Started

2 Data collected

3 Briefing

4 Editor review

5 Complete

 

But I just want:

Not Started

Data Collected

Briefing

Editor review

Complete

 

If I don't include the IDs in the value list then the status types are ordered alphabetically.  Anyone have an idea?

Thanks

Outcomes