Aye, I've seen some 3 slightly different versions of my NewID() from this thread. It's one I acquired back in VFP 3 and have used without problem ever since so saw no need to scrutinise or alter ("if it ain't broke ...").

Bear it in mind though! :-)

Terry

>There are several ways to get autoinc in VFP 6.0. I've had several people question my method that uses FLOCK(), but it has been stressed tested with hundred of users and at multiple locations.
>
>
>>Can't say's I have. Maybe it would. Systems I've written don't tend to have loads of people all trying to do such things concurrently. Thanks for the input. Maybe Ramon can alter his code accordingly, if he's used it. It's interesting how we scrutinise each other's code, when put up as a solution, isn't it, even if it's not germane to our requirements at the time.