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