I am trying to show the the record navigation with the get functions but something does not seem to work. I use the Get(TotalRecordCount) function in a field which correctly shows the total number of record, but in a found set, the other two calculated fields that have the functions: Get(RecordNumber), and Get(FoundCount) function, display the incorrect answer.

I have submitted the example, what I want to show is the correct number of records in a found set and the corresponding record number in that found set, in other words duplicate the information that is on the status bar. What I am doing wrong?

Get.fp7.zip

You need to make the Calculations "Unstored"

And use these functions.,

GetRecordID

GetFoundCount

GetTotalRecordCount

HTH

Lee

Get(RecordID) wouldn't help here.

Use Get(RecordNumber) to show which record of the found set you are looking at. Then, as Lee said, set the storage of all three fields to Unstored.

Thank you Lee, I will try it.

oops.

Good catch.

Lee