Hi everybody,

Bellow are the threads which describe the problems I encountered using AutoInc fields with CA in VFP8 (it's a bit easier with VFP9, but perhaps still not worth it):

AutoInc value and CA Thread #1191628
Interface ideas for simple Many to Many table Thread #1184320
Problem with CursorRefresh after adding a new record Thread #1192972

There were some other threads on the topic as well.

I've been able to make it work in my application, but now I would use GUID or NextID() approach instead.

Hope this helps and if you have a different opinion or some suggestions, I would appreciate them.