I think you can better save the increasing number in a table.
You also can use record locking then to avoid that other users increase the same value too at the same time.
Look for this at the TasTrade NewNr() Function.
It has that behavior.

Hope this helps,