>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.
Mark McCasland
Midlothian, TX USA