>>>WOW! What a post :o))))))))))))
>>>In my 22" wide screen monitor it didn't fit :-)))))))
>>>
>>>Which field is AUTOINC?
>>>Just remove it from UpdateNameList.
>>>
>>
>>The first field OptsID is the AutoInc. Let me remove it.
>>
>>Also, do I have to specify UpdateCmd, InsertCmd? And InsertRefreshCmd ? I forgot all these details, I think we discussed this before.
>
>There is no need except you want to change default CMDs generated by VFP.

I tested them in run-time and both UpdateCmd and InsertCmd are empty. TableUpdate shows .T. but does nothing.

This is UpdateFieldList

OPTIONID, MAKEID, MODELID, RETAIL, COST, COSTLINE, CTYPE, STDOPTION

(In the table the field name is Type, but in the CA I named it cType to avoid using reserved words - could be also present a problem)?

Do you know what I'm missing?