Get(RecordNumber) does not work
I want to create a field that always returns the sequence record number of the found set. According to FM help, Get(RecordNumber) should return this number but it just keeps returning the record number of the entire file and does not change with the current found set. So if I Find a group of records that has a total of 10 recored, the Get(RecordNumber) should not return a number greater than 10, but it keeps returning the record position of the entire file.
Why is this happening?
Also, I remember using a character set ( like ## or something like that ) that when this text string was put in the layout, it also returned the current record number of the found set, but I cannot seem to find that anywhere.
Get ( RecordNumber ) works just fine. But your field is not updating as expected.
Make sure that the field is of type calculation, not number with an auto-enter calculation specified.
Make sure that the calcualtion is unstored. (Click the storage options button.)