Say I have two drop down boxes, and I have two columns then after I select the two columns that pulls from the stock tables to give me a total.. Whats the best way or does anyone have an example?
Ex Boxes - Yellow box - Red box = All the yellow and red boxes in stock ...
ex of a table boxes -
yellow box red box - 6 in stock
yellow box pink box - 7 in stock
yellow box red box 8 in stock
two drop downsthen = total
total <red > <yellow boxes> = 14 boxes
any suggestions or pointers would be greatly appreicated.