I'm trying to update data using the ado dataenvironement with joined tables, and primary keys.

example:
mysql = "Select * FROM Inventory INNER JOIN ON "

.....more code ......
de.command(scommand1) = mysql
then I select the cursor types etc.

with rscommand1
if len(text1(part)<> 0 then !Partnumber = text1(part)
.... more code .....
.update 'this is where I get the error...(insufficient key column
information.....)

end with
'the Partnumber is the primary key.
can anyone help? Thanks