insufficient key column information
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