I agree that the table structure needs work. But I have questions:
1) What happend in the 10th month? Do the prices shift down 1 month and the first month price disappears?
2) Do the prices need to be in month order? What happens when Jan rolls around?
3) Do all of the prices change every month?
4) Does every product's price change every month?
5) Do you need to keep a long term price history?
My idea of the table structure:
Code:
tblProduct
---------------
ProductID Autonumber PK
Other fields(other product information)
tblProductPrice
---------------
ProductPriceID Autonumber
ProductFK LONG - FK to tblProduct
PriceDate Date of Price
Price Currenct - Price of Product