How to insert data from other tables when the destination table has primary keys : I need help creating a table the can track a 2% yearly price increase over the years 2010-2016.[My create statement is as follows][1]

  [1]: http://i.stack.imgur.com/M5hCu.png

I have 24 products and the starting price in my Products table that need insert into my new table. In theory I should have 192 records. I need help populating the year column so that it can cycle though 2010-2016 for each product. I also need help referencing the pervious year price for the next years calculation. 