>Hi Anton,
>
>Ed's idea worked for me, but I found a serious flaw in my implementation. When I designed my database (native VFP), I took AutoInc for my PKs. HUGE mistake! Now I'm in a catch 22 situation, because after I inserted a new record in a table I can not get my PK back. It looks like I have to switch to NextID() for now and use GUID in all other new projects instead.
>
If I understand correctly the problem is not with Autoinc itself. You cannot retireve new id because CursorAdapter doesn't return it, correct? VFP9 Help implies that AfterInsert event could be used (actualy it says for ADO source), i.e. record pointer didn't move yet.
Edward Pikman
Independent Consultant