Bad Programmer!

Now redo your program to :
1) open ID table
2) seek table your trying to get key on
3) lock record for that table
4) grab that value to a memvar
5) upgrade that value by 1
6) UNLOCK the record
7) go back to what you were doing.

__Stephen Russell

>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