AnsweredAssumed Answered

Finding a specific record in a sorted subset

Question asked by wladdy on Oct 21, 2012
Latest reply on Oct 22, 2012 by philmodjunk

Title

Finding a specific record in a sorted subset

Post

      

     Table has two fields: “pk” and “LetterCode” (text), which can be any one letter.

     I need a script that, when given a variable $pk corresponding to a valid pk value, will return the next pk value when table is sorted by pk and LetterCode =”A”.

     I go to the table’s layout, I find only “A” records and I sort the results by pk. Now, I’d like to go to record pk=$pk and use GetNthRecord to find what I need.

     Unfortunately, I don’t know how to go to record pk=$pk without losing the LetterCode=”A” filter.

     Your ideas would be much appreciated.

Outcomes