Hello Bob,

To create a subreport what you need to do is design a report in your sub-database that displays the information you want to display. Then design your report in your parent database that shows the information you want to show from the parent database. Then in the group Body add a subreport element using the layout element adder. When you add the subreport element to the report you will be prompted to pick the report to display and the link of the records to display.

-Ray

Hello Bob,

Okay I see what you are after now. To create a report like this what you want to do is create the report in your song database, sorted alphabetically by song title. Be sure to add the element that you are using as the relational link between the parent and child records. Then in the Group Header add a static text element for CD Title and another for Location. In the group body add two unbound value boxes named CDTitle and Location. Now on the left hand side under commands click on Program Layout. Under element choose CDTitle. Enter the following program(You may need to change some names as I do not know what you have named things in your file)

CDTitle = @XLookup(@FN, CDNumber, "Cds!CDNumber", "Title")
Location= @XLookup(@FN, CDNumber, "Cds!CDNumber", "Location")

In the above programming the first CDNumber is the name of the element in the report that has the value that is used for the relational link to the parent. The "Cds!CDNumber" is actually two pieces of information. "Cds" is the name of your parent form, "CDNumber" is the name of the element on the parent form that has the value in it that is used for the relational link. The exclamation mark is required to separate the two pieces of data. The last section of each line is the name of the element on your parent form that you want to display the data from, In this case "Title" and "Location".

If you have any questions about any of this just let me know what you have a question about and I will do my best to answer it.

-Ray