Hi Renoir

I found Out the answer already, Its due to the setting of the key field.

Thanks

>Patrick,
>
>If you send me the form and underlying data and classes (if any) and I will take a look at it. Zipped would be best to renoir@bellsouth.net.
>
>Renoir
>
>>Hi all
>> I have a DBC that consisted of 3 RV (teacher,education,employment) that connected to SQL Server 7.0, Education & Employment has a view parameter of tcode. I create a form that consist of this 3 Rv. Teacher update,edit,delete
>>work find but for education when i update one record field,.. it updated all the other records too with same data.
>>But when i try on the DBC, it works fine .
>>I haven't try on employment
>>
>>Teacher table
>>code Int (PK)
>>..
>>...
>>
>>Education table
>>Code Int (normal Index)
>>...
>>...
>>
>>Employmeny
>>Code Int (normal Index
>>....
>>...
>>
>>Pls Help