I have created an updateable cursor in a cursor adapter hitting a Fox database ("Native" ). The .Fill() command works and the view(?) is created. I have set AllowUpdates to .t. and left the .UpdateCmd empty. The cursor only has two tables ( table1 and table2 and both have a candidate key on an id column ). I have set the .KeyFieldList equal to both ids ( "id1, id2" - not qualified ). When I change an updateable column in the cursor and fire a TableUpdate() I get an error that says I have not set the KeyFieldList property for a specific table. I look at the object in memory and the property is set to both tables' id fields.

If I try to create the cursor and set the .KeyFieldList to a qualified table.fieldname for the keys the .Fill() gets an error and says the KeyFieldList is wrong, so it won't let me qualify the keys list.

In Fox 7 when you wanted to set a view KeyFieldList you set it by Viewname.idfieldname. This also does not work ( cursorname.idfieldname ).

Can someone tell me what I am doing wrong?