Re: set datatype

[Steve Moore]

Hmmmm, I'm not sure what you mean. There will be a subtable that stores the values of the numbers. However, I'm not sure how I would break the information out anymore. It would be silly to have a table that would store every possible combination.

Product Table:

ID: (int primary key)
Name: (var(50) - The actual name of the product ie "Ultra 1")
SwitchType: (var(50) - This stores the possible options ie - "1;3;4"


Switch Type table

ID: (int primary key)
Name: (var(50) name of switch type ie - "cable or telephone"


I need to be able to get a product from the product table and list its possible switch types


Name:
Ultra 1

Available Switches:
1: Cable
3: Telephone
4: Microwave

There might be 20-30 types of switches. Most products will have 3-6 types available.

I'm not a n00b at this stuff I swear. Just never run into this situation.

Thanks for your help