I am trying to layout a report that is based on a one-to-many relationship. However the child records will be made up of two tables and I want to print the last 10 records from the child tables in each their own group. In other words:

PARENT RECORD (1)

Child Records Table 1 (Last 10 Records)

Child Records Table 2 (Last 10 Records)

I'm not planning on defining a dataenvironment for this report, rather using a SELECT statement in my button code.

How do you define multiple Detail bands? Or can you? After this report I have another one to design that will involve 5 child tables.

Any suggestions?

Thanks
Elgin