I'll have to try again because I chenged the settings so many times that i can't remember. The only thing I remember is that iwas not satisfied by the CA behaviour.
I'll let you know tomorrow as is a little bit late here to be at work!!
:-))
Thank you All

>When the TABLEUPDATE() returns .t. is teh new record is inserted in the actual table?
>
>>TableUpdate returns .F. if I modify an existing record and .t. if I insert a new record.
>>
>>>What TABLEUPDATE() returns? .t. or .f.. If it returns .f. You can use AERRORS() to check what cause the problems
>>>
>>>
>>>>Yes I set that property and I also tried with other settings.
>>>>The only way to have my Table updated is to select all fields as Key
>>>>but it doesn't seem a good way to use Cursor Adapter.
>>>>
>>>>>Hi Alessio.
>>>>>
>>>>>>I'm having problem using CA. When I modify records in a CursorAdapter I cannot update the main table.
>>>>>>I built CA with the Builder. Set the table optimistic buffer, the datasource is A Native VFP tables which belongs to a Dbc but data don't update.
>>>>>
>>>>>Did you set the update properties on the Auto-Update page of the CursorAdapter Builder? If you don't set those properties correctly, the table won't be updated.
>>>>>
>>>>>Doug