Get Function not working right?

[lonesomejubilee]

Hi,

I am trying to put in a generic code that returns "Record 1 of 25". Here is what I am using.. "Record "&Get(RecordNumber)&" of "& Get(TotalRecordCount). Unstored. But each time I go through different records the two numbers are always the same. (record 1 of 1, Record 23 of 23, etc.). What am I doing wrong?

Thanks

[Søren Dyhr]

Use @@ for the first half of it, and an unstored calc'field holding Get(FoundCount) put on the layout as a mergefield.

Following rule of thumb should be observed, when ever one of these status functions are required, should the field be UNSTORED.

--sd

counting.zip

[Merit Solutions]

Make sure your calculation fields are not indexed

[lonesomejubilee]

Thanks, it was the indexing/unstored issue! I thought I had it set up right, but I didn't!

[Vaughan]

Ummm, at risk of sounding like a nit-picker, there is a difference between "indexing" and whether the field is "unstored", although they are related.

In this case the issue is the storage of the field: it needs to be set to "unstored" to force FMP to re-calculate it every time is it required.