i am trying to set up a db for purchasing laminates but cant get my head around the right way to structure the tables.
Each order would consist of
1. selecting a supplier
2.selecting a brand of laminate from that supplier
3.selecting a colour from that brand
4.selecting a finish for that colour
That part i can understand,but where i struggle is
once that product has been selected,you then have to select a sheet size
that the supplier carries,which varys depending on what laminate was selected,and the price of the laminate selected may or may not vary depending on
1.the sheetsize
2.the qty ordered, eg 1-5 sheets $10 sq/m, 5-20 sheets $8 sq/m
also in a range of 2000 colours 500 of those may all be the same price structure so how could you update the prices in 1 place only
can anybody suggest the most effecient way to organise the tables so that the user has the minimal data entry.
many Thanks in advance
Each order would consist of
1. selecting a supplier
2.selecting a brand of laminate from that supplier
3.selecting a colour from that brand
4.selecting a finish for that colour
That part i can understand,but where i struggle is
once that product has been selected,you then have to select a sheet size
that the supplier carries,which varys depending on what laminate was selected,and the price of the laminate selected may or may not vary depending on
1.the sheetsize
2.the qty ordered, eg 1-5 sheets $10 sq/m, 5-20 sheets $8 sq/m
also in a range of 2000 colours 500 of those may all be the same price structure so how could you update the prices in 1 place only
can anybody suggest the most effecient way to organise the tables so that the user has the minimal data entry.
many Thanks in advance