3 Replies Latest reply on Jan 25, 2010 4:21 PM by philmodjunk

    Curious SORT fix

    firth5

      Title

      Curious SORT fix

      Post

      In my database I have a field which has several options in it's pull down menu:

       

      (I'm not going to go into details about why this data is what it is)

       

      0

      Couch

      Flyby

      I

      II

      III

      IV

       

      I've automated the SORT so that it will sort by value list order.

       

      Problem is, the file doesn't seem to recognize any difference between I, II, III and IV.  If I change them to be 1, 2, 3, 4, the data sorts properly.  

       

      It's not that big a deal to have it be 1, 2, 3, 4, but I'm curious WHY the roman numerals wouldn't work.  Any thoughts?