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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer