double record numbers - performance question?

[berre]

Hello,

I'm having a problem with our order database. Two people are using the db. Every time one of the 2 wants to create a new order record a counter is increased and the order number field of the new record gets an automatically assigned order number. Works fine, except that every now and then (once in a month or so) they get two times the same ordernumber. I've already explained them that when they create a new order, they have to make sure the first field is filled in, and they have to switch to the next field (to make sure the new record is really written). But it still happens. What can I do?

Could it be that my FMpro server (v5.5) puts his write-commands and other to-do's in some queue somewhere and continues with the application? Or are the changes applied really really immediately directly pronto right now without delay?

In case it's done whit a queue, could it be that, worst case scenario, I have to wait seconds, even minutes, before the changes are applied? The server also is a PDC, antivirus server, and does some printing from time to time.

Thx,

bart

[Anatoli]

Is it a counter in field updated by your procedure or autoincreased field?

[berre]

Sorry for the late reaction, Anatoli

I have 2 fields :

OrderNr. type:calculation options:Indexed,LastOrderNr. + 1

Last OrderNr. type:number

The script for adding a new record goes like this :

Enter Browse Mode []

Show All Records

Sort [Restore, No dialog]

Go to Record/Request/Page [No dialog, By Number...]

Go to Field ["OrderNr."]

Copy [select,"OrderNr."]

New Record/Request

Paste [select,"Last OrderNr."]

Go to Field ["Client"]

bart