1 Reply Latest reply on Oct 24, 2012 3:59 PM by philmodjunk

    Value List Sorting

    j_morris

      Title

      Value List Sorting

      Post

           Is there a way to sort by the first field but only show the second field when creating a value list using 2 fields?

           I have a table (1) with a serialized key that I'm linking to from another table(2). Table 1 contains data about a certain month year time period; i.e. April 2010.

           In creating the layout for table 2, I'm referencing the key and showing all of the available time periods and would rather not show the key value since it would make things a bit confusing; i.e. 4 April 2010 (since it was the fourth record created). However if I only sort by the second field I end up with a list that looks like this:

           April 2010

           April 2011

           April 2012

           April 2013

           and so on...

           This is how I would like the list to show up:

           January 2010

           February 2010

           March 2010

           April 2010

           --- (continue pattern)

           January 2011

           February 2011

           March 2011

           April 2011

           --- (continue pattern)