I am writing a script for a multi-user environment where when they click on "Add New Form" the computer will find the next number available and assign it to that form. (Easy enough.) Since it is a multi-user environment, I need to reserve that number so the next person doesn't use the same number. (Still not so bad.) However, if the person filling out the form changes their mind and cancels out of the form or clicks on another link or closes the browser, etc., the numbering sequence is messed up and it has to stay consecutive with no missing numbers.
I have thought about the most efficient way to make this happen and all that has resulted is my head hurts :)
Has anyone done anything similar, and if so, what method did you use?
Thanks.
I have thought about the most efficient way to make this happen and all that has resulted is my head hurts :)
Has anyone done anything similar, and if so, what method did you use?
Thanks.