Eric,
Sorry I haven't made myself clear. I've attached the small amount of data I've placed in the sizes table.
My thinking was, and as I said before if it's wrong you are welcome to correct me, that I have a column in the items table that relates to SizeCatID. So let's say an item has a 2 in the SizeID Column. In the sizes table, a 2 means that there is an 8x10 print for $15.00 available and a 16x20 print for $60.00 available.
Another item might have a 1 in the SizeID column, which means that only an 8x10 for $15.00 is available. (an 8x10 may not always be $15.00 which is why I'm listing a price in the table as well)
So, my idea was that whatever the ItemSize value was for an item it would then generate a drop box that listed all the options that were available for that Category based on the sizes table. I may be wrong as I'm not familar with SQL so I may have to change the tables around, which is fine. I want the most effective method and if I was wrong, well, wouldn't be the first time :lol:
