Appending Pictures [OLE Objects] from one table to another

[TOTCOM11]

I have two tables. One called tblPictureIndex and one called tblPictures. TblPictureIndex has the fields ProductID (Primary Key), PicID1, PicID2, PicID3, PICTURE1, PICTURE2, PICTURE3. TblPictures has the fields PictureID (Primary Key) and Picture. PICTURE1, PICTURE2, PICTURE3 and Picture are OLE Object fields which contain different pictures. I want to write a query which looks at the PicIDs in TblPictureIndex and stores the corresponding picture in the field PICTURE(1,2, or 3). I already have the ID numbers filled in for all the fields. I have all the pictures copied into tblPictures and now want to copy these pictures over to the other table in whatever field which has the same picture ID number. The reason I am doing it this way is because there are some Products that will use the same picture. This way I don't have to copy picture #1 to every field which corresponds with an ID number that is also 1. I understand this is confusing. Please ask any questions if you need clarification. How do I write this query, and does it take multiple queries to get this right?