Hi,
I have rather simple db with next tables: Product (ProductID (primarykey), ProductName), CColor (CColorID (primarykey), CColorName) and Uses_Color (ProductID (primarykey, foreignkey), CColorID (primarykey, foreignkey), Description).
For instance, tables could look like:
Product:
1, Product1
2, Product2
3, Product3
CColor:
1, White
2, Black
3, Blue
4, Red
5, Yellow
Uses_Color:
1, 1, Description1 (Product1 has White color)
1, 2, Description2 (Product1 has Black color also)
On web page, for a selected product, I want to be able to add additional colors but only those that are not fould in Uses_Color for that selected product. It means that for my test product Product1, I would be able to choose only 3 remaining colors: Blue,
Red and Yellow not found in Uses_Color.
Regarding controls on that page, I have a Details ...
Go to the complete details ...