How can I combine the Sales Header (36) and Sales Header Archive (5107) tables along with their associated details from the Sales Line (37) and Sales Line Archive (5108) tables? We need to report for a given date range that spans both sets of tables.
I can create arrays for the No. fields in the header tables and then do a Union to get all of the Header No.s, but how do I match up the Sales Line and Sales Line Archive tables to their associated headers? Any ideas and/or suggestions would be welcome.