Databases
Code: Select all
Categories
Catid Cat Name
1 Small
2 Medium
3 Large
----------------
I want to add these categories
4 Red
5 Blue
6 Poly
7 Cotton
Items
Item Color Size Fabric CatID
Shirt1 Red Small Cotton 1
Shirt2 Red Medium Cotton 2
Shirt3 Red Large Cotton 3
Shirt4 Blue Small Poly 1
Shirt5 Blue Medium Poly 2
Shirt6 Blue Large Poly 3I am curruntly able to select a category and show the details with no problems. But I cannot make an item have more than one category. I would like to be able to select 1-7 (category) and give me the proper result.
Any suggestions would be appriciated.