>
>Just before saving the record you're editing,
>lock the number table,
>gather the next document number,
>unlock the number table
>store the retrieved next number to the record you're editing
>save the record you're editing


This is OK with VFP tables but my question was about client/server : how do you lock a C/S table (let's say SQL7) ? But I think the answere comes in the reply of Bob Archer (see next)

Thanks anyway and BTW : I think your lock comes to soon (should be after the numer-table update ...)