5 Replies Latest reply on Aug 2, 2016 2:19 PM by realgrouchy

    Filtering portal records for sorted related records

    realgrouchy

      I have a related table for records which are entered not in alphabetical order, i.e. "Bert, Elle, Fred, Debra, Al, Greta, Chris"

       

      I want to have an array of portals that take these values, sorted, and shows every other one. (So I can put them side-by-side and have the list go L-R)

       

      Currently, I can get them to do this by filtering each portal by "Mod ( Get ( RecordNumber ) ; 2 )" and "1 - Mod ( Get ( RecordNumber ) ; 2 )":

      Portal 1Portal 2

      Bert

      Fred

      Al

      Chris

      Debra

      Elle

      Greta

       

      I can also get each portal to sort its records, i.e.:

      Portal 1Portal 2

      Al

      Bert

      Chris

      Fred

      Elle

      Debra

      Greta

       

      But what I want is:

       

      Portal 1Portal 2

      Al

      Chris

      Elle

      Greta

      Bert

      Debra

      Fred

       

      I can't figure out a way to assign numbers to the sorted records in such a way as to allow me to filter each portal by the proper numbers.

       

      Any ideas?

       

      - RG>