I think I am getting it
Here is my summary
tblitem
ItemID | Name __ | ItemNo
1 ____ | Product a | 1234
So the tblitem contains all the info that does not change like a part of the item no., contents, thumb and detail jpg, laundry sign ...
tblsize
SizeID | Description
1 ____ | M
2 ____ | L
tblversion
VersionID | Description
1 ____ | x
2 ____ | y
tblprize
ItemID | SizeID | VersionID | Price | completeItemNo
1 ____ | 1 ____ | 1 ______ |10.00| 1234-x-M
1 ____ | 2 ____ | 1 ______ |20.00| 1234-x-L
1 ____ | 1 ____ | 2 ______ |12.00| 1234-y-M
1 ____ | 2 ____ | 2 ______ |22.00| 1234-y-L
tblprize would also contain other information like a code number unique to that item.
I will try to create the test tables tomorrow morning. I hope I don't bother you too much.