If you know how to write a SELECT query to get what you want then you just do an
INSERT INTO tblNameHere (columnlist) YOURSELECTSTATEMENT
Just make sure you account for previous records their, something like
LEFT JOIN tbl2
ON tbl1.PKID = tbl2.FKID
WHERE tbl2.FKID IS NULL
will eliminate the items already in you table from being selected from tbl1.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)