This question is a sought of follow up question to my last one.
I have a document with 10 product fields in it. Each field is a combo box which looks up the same product table. Next to the product codes is product qty also 10 of these fields qty1 qty2 qty3 and so on.
What I need is to be able to total the quantity of each product code that appears in any of the 10 product fields, can any one tell me how to do this ?
Example of Doc