Hi
I'm working on a product database which store product attributes.
A product has a field named "category_set".
This field should determine which attributes the user can see and edit in a form.
I have about 20.000 products and 50 different category_sets, which contains up to 250 different attributes.
My product table named tbl_products contain this fields:
SKU
Productname
Category_set
Examble data:
1000 Demoarticle A Wheel
1100 Demoarticle B Engine
My category_set table named tbl_categorySet contains this fields:
Categoryname
Attributevalue
Examble data:
Wheel Size
Wheel Pattern
Engine Volume
Engine Cylinders
Engine Turbo
My attributevalue table named tbl_attributevalue contains this fields:
SKU
Attributename
Atttributevalue
Examble data:
1000 Wheel 17 inch
1000 Wheel Slick
2000 Volume 2000 ccm
2000 Cylinders 4
2000 Turbo Yes
How can I make the form only showing the relevate attributes, then the category_set is selected for a product?
Is there a better way to store data, than my current solution with 3 tables?