record number in sorted found set

[tomp]

I would like to display the record number in a sorted found set. 'Get(recordnumber)' seems to return the record number in the unsorted found set whether or not the found set is sorted.

Is there a function that returns the record number in a sorted found set?

[LaRetta]

Type @@ on your list row or you form layout. This won't work in table layouts however. If you want it displayed on table layout then you'll need to create a calculation (number) with:

Get (RecordNumber)

... and place the calc on the layout and be sure to set the calculation to unstored (check 'do not store' ) in the Storage Options.

If you want it to display your ID, you need to create one ... an auto-enter serial which will remain the same number no matter how sorted.

Edited June 14, 2010 by Guest

[tomp]

THANKS! @@ works like a champ.