AnsweredAssumed Answered

Filtering portal records for sorted related records

Question asked by realgrouchy on Aug 2, 2016
Latest reply on Aug 2, 2016 by 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>

Outcomes