well, i must not be smart enough to figure this out on my own...yet.
The system is working with the add 1 on the number but here is the new challenge and I can't figure it out.
Let's say that the number goes from 00001, 00002, 00003, 00005, 00006, etc.
The way the script is running through the record set, it is telling us that 00006 is the highest number and the new assigned number will be 00007.
We want to catch 00004 and assign the machine to that number. This way we won't have huge gaps in the numbering sequence.
I looked at using an array instead of an if statement but cant figure out how to get the 00004 value.
Could you shed some light on this???
_________________________
John
LM Contractor
One of the
2 dads
