So I forgot to turn on the feature to Serialize Records.
So I need to do it manually on the existing records and then have the auto-serial continue where I leave off.
But my loop script is not working for some reason.
I am starting with ID IL00006
My Script is as followed:
Go to First Record
If (not IsEmpty(table::tableID) )
Go To Next Record ; Exit After Last
Set Field (table::tableid ; table::tableID + 1
Go to next record ; exit after last
I have also tried it with setting the ID as a variable
Set Variable ($ID ; table::tableid + 1)
And I have also tried setting it like this as well:
"IL00006" + 1
The interesting thing is that the returned value is an 7.
Does not even return the IL000007 that I would expect.
Thanks guys. Pretty dumb mistake I know. And out of all the other tables, it was the only one that I missed.
Thank you all.