I am trying to think of a way to convert random autonumbers into incremental numbers. I am going to have a multi-user environment and want to make sure that when they sync their data that nothing is overwritten.



I have a field called Report Number set as a random autonumber. This will help eliminate syncing over the same reports. However, I need to have the numbers be incremental.

My thought is to write some VBA code that turns the random autonumber into the next number of the report.

Example: I have Report Number 3269483. I sync it and the VBA code tells itself that the last Report Number saved was 3 (after the conversion for the last random autonumber), so it now turns 3269483 into Report Number 4.

I have two thoughts on how this might work:

1) A string of code that somehow does this and first checks for the last Report Number and adds a +1 to it.

*2) Populate a list so that it starts from 1 and goes to 2147483647. The code then checks for the next number in the sequence and uses that for the Report Number. This may require a second field for the incremental number to be placed in.

Maybe DLast/DMax could help out here somehow?

If anyone could point me in the right direction or tell me what to look for, that would be awesome!

Thanks.