>What is the most flexible way to produce a report from tables in parent-child relation? In other words, if I have a parent table and several related child tables on a common key, what is best way to show them all in same report?Charlie,
Off the top, I can think of a couple of ways. One would be to join the tables on the key and the resulting record set would include every child record. Another way would be to insert a subreport into the main report, where the subreport would be the child table and the link between the 2 reports would be the common key.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer