The RecordID is the chronological record number. The RecordNumber is the record number based upon the found set and/or sorted order. If you are showing all records and unsorted, the RecordID and RecordNumber will be the same.
For all of the records I displayed in Table view, the Get (RecordNumber) definitely returns the number of the record. If I'm active in record "m" or "n" records, Get (RecordNumber) returns "m".
If you are showing all records and unsorted, the RecordID and RecordNumber will be the same.
another condition must be true: you NEVER had deleted a record, otherwise the RecordId and the RecordNumber will be sometimes ( more than one time ) different.
How can I get the current record number of the cursor
position (in Table View) to store it in a global field ?
you can't store the current record number into a global field but you can if the field is a calculation field with calc: Get ( RecordNumber ) UNSTORED.
Place that field into the Header part of the table and make the header visible in table view by going, when in layout mode, into menu:
Layouts >> Layout Setup... >> Views >> Properties... >> include header part
I have marked your answer as a "solution". Thank you very
much for your help. The trick was to place the field into the
header and not have it as part of the table. Thanks again.