M
Matt
I have a Products table that has a Product ID, Product Description, and
Product Type field. The Product Type field is combo box with 4 different
values (Wood, HPL, Melamine, Other). I would like to add fields for each
specific Product Type to make data entry easier.
Example: For HPL I would like to add the following 4 fields:
SHEET SIZE: 4 x 8 (this would be a combo box with a list of values)
MANUFACTURER: Formica (this would be a combo box with a list of values)
FINISH: Suede (this would be a combo box with a list of values)
GRADE: Postforming (this would be a combo box with a list of values)
I would like to add fields, like the above example, for each Product Type
(of course the fields for each Product Type would be different)
Should I add all of the different fields in the current Products Table?
Should I create seperate tables for each of the different product types?
Thank you in advance for all of your help.
Product Type field. The Product Type field is combo box with 4 different
values (Wood, HPL, Melamine, Other). I would like to add fields for each
specific Product Type to make data entry easier.
Example: For HPL I would like to add the following 4 fields:
SHEET SIZE: 4 x 8 (this would be a combo box with a list of values)
MANUFACTURER: Formica (this would be a combo box with a list of values)
FINISH: Suede (this would be a combo box with a list of values)
GRADE: Postforming (this would be a combo box with a list of values)
I would like to add fields, like the above example, for each Product Type
(of course the fields for each Product Type would be different)
Should I add all of the different fields in the current Products Table?
Should I create seperate tables for each of the different product types?
Thank you in advance for all of your help.