Create Detail Tables
You can add additional detail primary tables to frames generated from the master_detail and detail frame templates.
To create an additional detail table
1. Create a new master-detail frame.
2. Select the master primary table icon in the query display area.
3. Click Add Detail Table.
The Select Database Object dialog appears.
4. Enter the name of a detail table in the Detail field.
For more information on using the control button to the right of the entry field to specify a table, see
Table Selection Dialog.
5. Click OK.
The detail table icon and a new join icon are added to the query display area.
6. Insert a join between one or more columns by clicking Default or Insert for individually selected columns.
A line is drawn between the columns indicating the join.
7. Set the desired query and display properties for the new master-detail relationship.
For more information, see:
8. Click Generate.
The frame is created and displayed in the Frame Editor.
9. (Optional) Specify the frame's properties using the Property Inspector. For example, set the IsResizeable property to TRUE.
10. To see the additional detail table in the frame, click Debug, Go on the floating menu bar.
The frame appears containing the additional detail table.
11. When you are finished, close the running frame and then click File, Close to exit the Frame Editor, saving changes appropriately.