Hello All,
Today I created my first view ( local ), to my amazement it worked pretty well straight away. It is bases on a single VFP table and is parametised, ?thisform.clm_ref.value. I set the update criteria to update all & Perform SQL updates and accepted the default check boxes. From within the form I issued a Tableupdate(1) with buffering set to Optimistic Table. All my changes were written to the base table without a hitch ( I tried this several times ) I like these views thought I, then I don't know what I did but!!, if I now edit a field in a single record in the view ( not the primary key ) all the records in the base table ( with the same key ) inherit this change in value.
e.g
1)I enter E10126 in thisform.clm_ref
2) Requery('myview')
3) The grid has three records in it
4) I change one field value in the first record
5) I issue Tableupdate(1) ( the status bar reads 3 records updated )
6) I issue Requery('myview') to see the changes
7) All the records have inherited the change.

I created another view using a different table ( using the same commands as above )and all is fine, what have I done wrong?
TIA
Pete Kane