>An application I wrote for a client some time ago involves keeping track of people in a camp ground. The program automatically assigns a confirmation number by using a CALCULATE MAX() command on the field that contains the confirmation number. I then add one to that number and store the new number in the confirmation number field. It works fine unless multiple users on using the system. Then, occasionally, the system generates two of the same confirmation number. What is the best way to handle this type of problem on a network?
>
>Thanks in advance...
>
>John Dennis
I use SYS(2015) to generate unique numbers. It's not a counter and is character but it works in most small to medium systems.