2 Replies Latest reply on Oct 22, 2012 9:04 AM by philmodjunk

    Finding a specific record in a sorted subset

    wladdy

      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.