>Hi!
>
>If you're interested, the way of doing it for VFP datatbase is described in FAQ article at the www.tek-tips.com site. We used the approach described there for years without any conflicts, but with some restrictions that are described in that FAQ article too.
>

Are you using a pseudonym (?? - spelling) there? Hi, Tom :)

You FAQ How to organize auto-increment key field in VFP?
faq184-259 has few minor problems... First of all, you need to ensure, that the NextID table is opened for the correct database. We had situations using code like yours, when incorrect NextID table was opened. So, I added a check for this into our lNextID function...

>>Hi all,
>>
>>If you are interesting for a generation primary key problem, you can read an article "The easy way to form a primary key" at http://www.geocities.com/vhpcg/primkey.html
>>
>>Best regards,
>>Vladimir Trukhin