Retrieve a sequential number after a record sort- FM 10
I have created my own "record browsing" arrows but would like to report which relative record I'm on AFTER a sort (just like is reported in the default "status toolbar" record number box). Unfortunately Get(RecordID) retrieves the unique record number assigned when the record is created, and Get(RecordNumber) retrieves the sequential record number PRIOR to a sort. Once sorted those numbers get out of sequence.
Is there a solution? If I could only snatch the source for the number in the default "status toolbar" record number box.