I have a badly designed database but, here is what I need to do. I need to return the results of 3 tables
For a given work order table2 may have 2 records and table3 may have 3 records. Can I use a report that will pass the result set to two subreports? For example I may have filtering criteria on the main report that would tell it to only include data for work orders 1, 2 and 3. I want the 1st subreport to return the lines for labor for those work orders and I want the 2nd subreport to return the parts that were used for those work orders.