I mistakenly posted this in the wrong forum. (VB-Beg) I think it should go here.

I am trying to adapt the Address Book program found in Beginning VB 6 Database programming by John Connell. His program uses one main table to populate the form and the Add new method to add records, but the table I need to add data to is dependant on 2 other tables related to my table by their PK's. I don't need to update them, but I need their PK info in order to update my main table. How? I use a Recordset created by the SQL INNER JOIN to populate the text boxes but I cant figure out how to update my table. I get field cannot be updated error message. Thanks