Speed of update record?

Speed of update record?

I have a system that generates work order numbers. There is a form with a single record that contains the next work order number. When a new work order form is opened the following code is in the on load section.

//Get the work order number record
Next_WO_Num_Record = Next_WO_Number[Record_Name == "ABC"];
WO_Number=Next_WO_Num_Record.Next_WO_Number.toString();
//Update the work order number record
Next_WO_Num_Record.Next_WO_Number=(Next_WO_Num_Record.Next_WO_Number  +  1);

If two people open a work order screen at the same time they both get the same work order number. Shouldn't the 3 statements happen in milliseconds?

Is there a way to lock the WO Number Record and unlock it when the update is written?


Herb Wexler