Base Price Contingent on multiple fields in table
Help Please,
Would like to modify PowerStore 2 for pricing from look up query need help,?
Here is a sample of Price Table,
(pcode=Product Code),(width=width),(drop=Length),(table=Price Table name),(price0=BasePrice),(price1=option1),(price2=option2),(price3=option3)
Prices would be contingent on pcode,width,drop
pcode | width | drop | table | price0 | price1 | price2 | price3
10000 | 24.000 | 30.000 | wb2in | 113.00 | 8.00 | 0.00 | 0.00
10000 | 24.000 | 36.000 | wb2in | 129.00 | 8.00 | 0.00 | 0.00
10000 | 24.000 | 48.000 | wb2in | 154.00 | 8.00 | 0.00 | 0.00
10000 | 24.000 | 54.000 | wb2in | 170.00 | 8.00 | 0.00 | 0.00
10000 | 24.000 | 66.000 | wb2in | 203.00 | 8.00 | 0.00 | 0.00
Thanks in advance