2 Replies Latest reply on Aug 15, 2017 11:08 AM by bob_w

    Reset ID Number in Sequence

    Mitch

      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