=TABLEUPDATE(.t.) problem when in multiuser environment.
I am using some some in to update auto referencing.

When first user logs into a screen he gets the next auto reference correctly i.e AB130 and the code has a =TABLEUPDATE(.t.) at this point and he starts to fill in the screen, the second user goes into the same screen and gets the next auto reference AB131 also correct and same code =TABLEUPDATE(.t.).
The first user clicks save and table is saved with correct values i.e auto ref AB130, then clicks new screen again but instead of getting the next auto reference AB132 he gets AB131 which is being used by the second user so when he has filled in the screen and clicks save, he gets duplicate reference message which is correct.

My question is why is the reference AB131 not being saved to give me the next correct auto reference?. How can I get it to commit in multi user environment?

Thanks