Get function

[musicarteca]

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

[Lee Smith]

You need to make the Calculations "Unstored"

And use these functions.,

GetRecordID

GetFoundCount

GetTotalRecordCount

HTH

Lee

[Ender]

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.

[musicarteca]

Thank you Lee, I will try it.

[Lee Smith]

oops.

Good catch.

Lee