I am running a chemistry and I sell drugs at differet prices depending on where a member belongs .e gold,silver,diamond. these are membership levels and for any given drug,the price depends on membership levels.
look here
DrugIg MemberLevel price
1000 gold 1200.00
1000 silver 1000.00
1000 Diamond 1050.00
When entering prices(on html form), you have to put the price for a given drug for each level
Question:
- Since putting prices across is difficult,then I want to put prices for 'gold' to be default and a member enters only the 'gold' and I automatically create it as difault price across all levels and give a discount later depending on where a member belongs.
Can somebody help me write the query that can multiply all this prices to all levels. ?