John,
thanks for the reply here is the SQL ;
SELECT *;
FROM employee!elements;
WHERE Elements.clm_ref = ?thisform.clm_ref.value
Thanks again

>Hi Peter ---
>
>What is the SQL statement that comprises your view? Also, are you using GROUP BY option in that statement? You can load the View Designer and right click, choose View SQL to see what the actual SQL statement is.
>
>
>
>>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