Troy,
I am not sure what your end goal is here but I have a couple of ideas.
I need to clarify though... are you simply just looking for a quick way to get data from two separate tables into this new table (meaning all the data is already in existence) or are you trying to create some sort of new form that allows a user to edit previous info and possibly add new info?
If you are just trying to move data, the best way would be to write a simple script that loops through a query result based on an inner join to merge the results of the original two tables and gets the data and then inserts that data into the new table.
Brian