modifying data in a vb.net form

[Signo.X]

when i try to modify some colum data manually - and directely from the Access DB it does accept the changes and updates the DB , but when i try to do the same thing in the form for the same colum, it said i can't modify the record because it relates to another table.

i under stand if the colum was the PK of the table and a FK for the other table i wont be able to change it, but why i cant modify the other data ?

it also says in the exception msg that a "record" cant be modofied..in my case, im only trying to change a "colum" data and not the whole record?
any thing to do with the update method for the data adapter?

in my form im only trying to Modify data from the Part table :

Part :
partCode - PK
partDesc
partPrice

OrderLine :

OrderNo - PK​

​

​

LineNo - PK
​

PartCode - FK ref Part
Qty

for examples if i try to modify an existing data in partDesc column manually using access..there will be no problems, but when i try to do the same thing from the form for the same colum it gives me an error. even thought the value doesnt relate or depend on other table

I only can modify/edit colums in the web forms that i have ADDED using the form..

Please Help!!

~signo.X ​