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.
If it's not broken, fix it until it is.
My Blog