AnsweredAssumed Answered

Value List Sorting

Question asked by j_morris on Oct 24, 2012
Latest reply on Oct 24, 2012 by philmodjunk

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)

      

      

Outcomes