Reset Auto-Enter next value

[Rodd]

I have a lot of connected scripts that import an old system data schema into a new and "improved" schema. My problem is that every time I rerun the scripts, I have to go and reset the "next value" field back to the beginning. Is there a way via scripting that I can do this instead of having to resort to going to every file?

[Fenton]

There is a "Set Next Serial Value" script step, in the Fields section. But one usually would be setting it to the last serial number in the imported data + 1, not "back to the beginning". Though it's up to you. There is also a GetNextSerialValue() function, in the Design functions section.

[bcooney]

if you create a summary field = max( keyID) then set the next serial to the summary field+1

[Rodd]

Thanks for the responses. I used the set next serial and it does exactly what I wanted. I want to reset to say "EMP000001" because I'm testing and debugging the import scripts, so going to the next highest isn't as clean as I want.