Jason, I have been thinking for a few hours now, trying to grasp it.
And it took me a while to understand your solution. But there is one thing I don't understand. itemName and itemContents originally come from 2 different tables. itemName is unique in tblProduct, but itemContents is not unique in tblPrice.
itemTextID | languageItemID | productItemID| itemName| itemContents
1 _______ |1 ____________ | 1__________ | productA | abc
So itemTextID would have to become a foreign key in tablePrice? I am thinking tblPrice is the compound table with room for double entries. With four languages,would that quadruple the number of entries in tblPrice?
I guess what I mean to say, I don't really get it. I have the tables down for one language, and I went with Craigs suggestion to make extra tables for price and size. But the language challenge ...