Complicated report

[AngeldelaNoche]

I have a report that gets its information from a header table (MTableA) and a detail table (DTableA). Is there a way to create a report where the header information is linked to a third table (MTableB) and the detail lines are linked to a fourth table (DTableB)?

[cstrasser]

Yes. But you might have to restructure the report.____The easiest way might be to create two reports that generate exports of the fields you want (one with the "A" table data and the other with the "B" table data). If you use RapidRunner, you can have them both export to a DBF as a lowest common format and then have the second report append data to the data table created by the first report.____Finally, you^d have a third report that took the output from the first two and produced the output you wanted.____Alternatively, you could do this in a single report, but you^d need another table at a higher level than the others:____TopLevel__|__------ MTableA__| |__| --------- DTableA__|__-------MTableB__ |__ --------- DTableB____You^d need something in common between the TopLevel and the MTables (perhaps a company code).