I am trying to build a catalog website where. In the categories, the fields for the products are different depending on which category. Some are common fields but others will be different between them.
These different fields could be of any data type and can be managed by an interface if need be.
Here is an example:
The DB contains: Category, Sub-Category, Product. The product could contain text field 1 to 10. But for Category 1 only fields 1,2 and 3 are used. For Category 2, fields 2,3,8 and 9 are used and so on...
Are there any existing examples or pre-built solutions out there than anyone can direct me too? A vb.net/sql server 2K solution would be perfect, but I can always try to adapt another solution if possible.