AnsweredAssumed Answered

Dynamic auto enterserial?

Question asked by Stu412 on Apr 1, 2015
Latest reply on Apr 1, 2015 by Stu412


Dynamic auto enterserial?



Not sure how to approach this.  I have a task which generates a whole bunch of new records on a given table.  By design, each time I run the task, it deletes existing records and replaces them with new, updated records.

I'm using the auto enter serial number in a resulting view.

Each time I run the task, I want this auto enter number reset to 1.  There's no risk associated here as this field will never relate to anything else.

Is there a way that I can tell the table involved to always reset to 1 when the script for my routine is run?