Be sure to right-click in the grids and navigator, there are plenty of features waiting for you!
Once you have set up the master-detail relationship, save it using the Save button on the toolbar. This file will contain all of the info necessary to rebuild all you have done. It will also contain any filters you’ve added to your datasets and the associated report if you created and saved one. Once saved, the file will appear in the dropdown under the Open button on the toolbar.
When you have more than 1 or 2 datasets, Right-click in the navigator on the node where you want to add the next detail dataset, then choose Add detail under current node.
Select an object as the master dataset using the dropdowns.
To select a detail dataset, click the rightmost toolbar button.
If the master dataset has one foreign key pointing to it, this will automatically establish the detail dataset
If there is more than one foreign key, you will be prompted to choose one.
If there are no foreign keys, click the 'define master/detail relationship' button in the detail panel to manually add a detail.
If the detail table has a foreign key pointing to some other table, you can use the dropdown part of the button to use the FK constraint “in reverse” – meaning the parent table in the FK relationship is shown as the detail table in the Master-Detail Browser.
Repeat to add more detail datasets.
Click the Generate Report button on the master dataset’s toolbar.
Answer the report wizard questions for the master dataset.
Add detail datasets to your report
Click Report | Data in the Report Designer main menu, and then add a checkmark next to your detail dataset.
Click the insert band button on the Report Designer left side toolbar.
Choose Detail Data and then click OK.
Drag detail columns into the detail band in the report.
Click Preview on the Report Designer toolbar to see the report.
Save the report definition to a .fr3 file using the toolbar button in the Report Designer.