5 Replies Latest reply: May 15, 2014 10:01 AM by Nick Osdale-Popa RSS

    Recno() question - Need unique number

      I'm working on a project that requires a unique sequential number.  The Recno() works great in most cases.  In my output from Monarch, I've introduced a filter that skips certain records.  The problem now is that the Recno() is no longer sequential as the records skipped take with it the Recno().  example:  Need records sequence 1 2 3 4 5 6 etc., with records now skipped due to filter, the sequence is now 1 2 3 7 9 10 etc.  While this is still sequential, the missing numbers are causing a problem.

       

      hgs