Hi all,

I am having a problem updating a CursorAdapter. The CursorAdapter has fields from 2 tables in the UpdatableFieldList. I have the KeyFieldList, Tables, UpdatableFieldList and the UpdateNameList properties filled in. The update command seems to be built properly, I put a message box in the CursorAdapter's BeforeUpdate method to make sure it is being created.

The problem is when I edit a field in the parent table. I get a message window saying 'Procedure canceled.' with OK and Help buttons. This only happens when I edit a field in the parent table. If I change a field in the child table it works properly.

The DataSourceType is Native. I'm running VFP 9 SP1. Any ideas?

Thanks