Hello every one, hope you are all nice and warm on this cold morning. I have built a database that is used of a retailer of clothing shop. They are a small one man business with one retail shop. with no buget at all.. My fee for doing this a pint when the lock down is over,
I need to add color options and size options (or choices) that the user can pick from.
i could make a table of sizes, like this.
table Name= sizes
record example
size id code= XXXX
Product id=XXXXX
SizeName= small ( example)
this would result is a table like this
SizeID Product ID SizeName
1 0012 small
2 0012 Meduim
3 0013 large
4 4560 36b
5 4560 36a
5 4560 32b
6 5694 28 insideleg
which then has to be linked the the main product table in a relationship. The are a few other ways I have thought of. but i would like to get peoples other option and other ways of doing it. with pros and cons it possible. The problem with is option is that the wold be a lot of duplication as below
side id size name product id
1 small 1234
2 medium 1234
3 large 1234
4 small 7891
5 medium 7891
6 large 7891
7 small 4561
8 Medium 4561
I don't want to pick a method and them find a better one a few days or weeks later.
Have a nice day
MIke
I need to add color options and size options (or choices) that the user can pick from.
i could make a table of sizes, like this.
table Name= sizes
record example
size id code= XXXX
Product id=XXXXX
SizeName= small ( example)
this would result is a table like this
SizeID Product ID SizeName
1 0012 small
2 0012 Meduim
3 0013 large
4 4560 36b
5 4560 36a
5 4560 32b
6 5694 28 insideleg
which then has to be linked the the main product table in a relationship. The are a few other ways I have thought of. but i would like to get peoples other option and other ways of doing it. with pros and cons it possible. The problem with is option is that the wold be a lot of duplication as below
side id size name product id
1 small 1234
2 medium 1234
3 large 1234
4 small 7891
5 medium 7891
6 large 7891
7 small 4561
8 Medium 4561
I don't want to pick a method and them find a better one a few days or weeks later.
Have a nice day
MIke
Last edited: