Why do you want to edit the Recordset, I thought it was for a Report?
It is better to have a Primary Key Linking the tables. I just wish I could work out what you want it to do so that I could try it myself.