Avoid Serial Dupes In Runtime Import

September 10, 200916 yr

[color:red]UPDATE: Apparently it was all the "0's" that caused the problem. I changed the Record Number Auto Enter to start with 1000001 and then imported the files and everything seems to work correctly.

I am working with an import script on a Runtime.

On the layout I have a field called “Record Number” this is an Auto-Entered Serial Number generated on creation. Example: 0000125

So I give the runtime out to the troops and then I need to do an update to a new version (and I set the "Record Number to 0000000" on the new runtime.

Since I do not know what record number each officer is on how do I have the new runtime import their data and not duplicate the “Record Number”?

I have tried to use the "Set Next Serial Value" and put it to + 0000001 but it reverts back to +1

And when I create a new record it starts at "1" even though record 00000123 is showing.

I am using:

Show All Records

Go to Record: Last

Set Next Serial Value

Any suggestions?

Jim

Edited September 10, 200916 yr by Guest