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