Subject Re: SQL or Array Rowset ? From Robbie Nott <robnott@mweb.co.za> Date Mon, 5 Apr 2021 15:10:12 +0200 Newsgroups dbase.getting-started Attachment(s) quoteitem.DBF, PackageInvTotals.DBF Hi Akshat Many thanks for the reply Attached sample tables When the quote is completed the program goes through the QuoteItems and builds an array of the unique part numbers and sums their quantities. Program then looks up the Accounts file with each PartNumber to get the NoOnHand ( DB's and CR's ) - this resides in a procedure CalcNoOnHand() Balance is calculated - NoOnHand - NoRequired Results are sent out to the PackageInvTotals table which displays on the form. PackageInvTotals table columns 1 to 3 will remain constant and I'd like to leave them alone. It's the last 2 columns in the output table - NoOnHand and Balance - that I'm needing help with... Again, many thanks Robbie