Hi, I have an application with, among others, a batch production table, with several lines for different batches of the same product. Also an invoice where I need to have one line for each product, with the correct total, as summarised from the production table. I have written a script which finds and sorts the relevant records, and calculates totals, but it has erorrs: some products get lost, while others still finish up with multiple (fewer than in the prod table) lines. Is there a standard method that I should use?
Thanks, Bill Groenestein