Hello all,
Our companies timber products are made up of five seperate componets.
These are:
Grade
Treatment
Dryness
Finish
NominalWidth
NominalThickness
In each category there are multiple options.
The combination of one selection from each category is the product code.
As you can imangine there are alot of possible product codes.
I think I want to set up the database so that a users selection in each category during either product data entry or order data entry will be stored as a product code in another table.
For example my product code for the following six selections would be stored in my product code table as M8LH31KDPG10050
Grade=M8
Treatment=LH31
Dryness=KD
Finish=PG
NominalWidth=100
NominalThickness=50
This would only happen once for each new combiantion of selections made.
Could anyone comment on this way of setting product codes up?
Can a combination of six selections be stored/populated into one table as a product code?
Any other advise would be appreciated.
Thanks
JohnG
Our companies timber products are made up of five seperate componets.
These are:
Grade
Treatment
Dryness
Finish
NominalWidth
NominalThickness
In each category there are multiple options.
The combination of one selection from each category is the product code.
As you can imangine there are alot of possible product codes.
I think I want to set up the database so that a users selection in each category during either product data entry or order data entry will be stored as a product code in another table.
For example my product code for the following six selections would be stored in my product code table as M8LH31KDPG10050
Grade=M8
Treatment=LH31
Dryness=KD
Finish=PG
NominalWidth=100
NominalThickness=50
This would only happen once for each new combiantion of selections made.
Could anyone comment on this way of setting product codes up?
Can a combination of six selections be stored/populated into one table as a product code?
Any other advise would be appreciated.
Thanks
JohnG