Finding a specific record in a sorted subset
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.