AnsweredAssumed Answered

Reset ID Number in Sequence

Question asked by Mitch on May 9, 2013
Latest reply on Aug 15, 2017 by bob_w

Title

Reset ID Number in Sequence

Post

     Hi,

     I have a large number (100) of portal records, and I wish to reset the field (Items_ID) that contains the sequential serial number, from first record to last record, giving them a new serial number in sequence from 1 through to 100, all increasing by increaments of 1.

     Finally, after the last record; 100, I wish to reset the next serial value for the Items_ID, on creation to be 101, increments of 1.

     Any idea of a script.

     Mitch

Outcomes