Oleg,

>in multiuser env without locking you can have the same ID for 2 users.
>Between SELECT and UPDATE someone else could issue SELECT an get the same ID.
>Thanks,
>Oleg

I agree, but take a close look at bob's code ; I think he handles this problem very creatively (only using VFP) !