Record number doesn't match

[Storm Cellar]

Hi. How can I be sure that the record number (defined field) matches the record number under the flip book on the upper left hand column? Have tried for 8 hours, but no luck. Seems when I delete or duplicate, the numbers change and don't match. Tried indexing, and all the usual. Thanks!

Terri

[Ender]

Hi Terri,

If it's for display purposes only, you can either use the @@ symbol in a text area on the layout, or an unstored calc with get(recordnumber) to show which number of the found set you are looking at.

But you should not attempt to use such a number as a relational key. For that, use auto-enter serial numbers, and don't worry that they are not syncronized with the current record number.