2 Replies Latest reply on Jan 24, 2007 1:13 PM by RyanG24

    qty update

      Hi i have 2 tables


      what i need to do is add to my Qty in the productsTable with the Qty from my OrderHistoryTable

      so i will be viewing on my output all orderitems that have a orderno of say 2333

      so this may have 5 different products with differnt PartNos

      i then need to match the part numbers with the part numbers in my ProductsTable and get the Qty and add the qty from my OrderHistoryTable

      i have tried a loop but it only updates the first item in my OrderHistoryTable any ideas how i need to change this