Mark,

been thinking more about this. I understand what you're saying here, and while
I might not need to update the left table in this case, it seems probable in
the future.

So how do I go about using a CA to create a join where only the changed record
in the left table gets updated?

Thanks



>>I created a join with a cursor adapter. I then changed values on the first
>>record, on fields from both tables, and when I did a TABLEUPDATE(), the field
>>from the Left table was changed for ALL records, and the Right table was ok.
>>
>>Anyone know what I'm doing wrong?
>>
>>Thanks
>
>What exactly do you want updated? The "right" table only? The key to this is to imagine what kind of SQL VFP is going to generate for you for the update based on the values of the following properties: Tables, KeyFieldList, UpdatableFieldList and UpdateNameList. If you do not want records in the "Left" table updated, leave that information out of those properties. If my assumptions are wrong, just post the values for those properties and what/how you want your data updated.