Hello Bill,

Yes, this is possible to do with a Mass Update spec. The programming would look similar to the following.

Var vControlNumber as Int

vControlNumber = @ToNumber(@GlobalValue("ControlNumber")) + 1
ControlNo = vControlNumber
GlobalValue("ControlNumber", vControlNumber) 

This code is using a GlobalValue to keep track of the last number assigned. so what you can do in programming is use that same GlobalValue to assign a ControlNo to a new record as it is added.

-Ray

Hello Bill,

I apologize. I meant Mass Update spec not Retrieve spec. I've edited my original post so as to avoid confusion in the future.

Yes the line ControlNo = vControlNumber is the line that sets the number back to the actual element.

-Ray

Ray...
I'm not having any success with this code.

I'm setting up a retrieve request that asks for all records with nothing in the ControlNo element.  Then I set up a Mass Update spec using the code you've given me.  When I try to run the spec I get the message "Some or all of this mass update has failed to compile.  It will not execute".

I'm going to try and attach a screen shot of the Program Editor "Error String" message so you can see it.

OK, I'll give that a try and see what happens.