8. Generating Frames from Predefined Templates : The mastdetl Templates : Add Additional Tables to a Generated Frame : Create an Associate Table
 
Share this page                  
Create an Associate Table
An associate table can be joined to a primary table to provide additional data. The columns from each table can be included as fields in the frame.
To create an associate table
1. Create another master-detail frame.
For details, see Create a Master-Detail Frame.
2. Select the appropriate table icon in the query display area.
3. Click Add Associate Table.
The Select Database Object dialog appears.
4. Enter the name of an associate table in the Associate 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 associate table icon is 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.
For more information, see How You Can Define Join Column Properties.
7. Select the associate table icon in the query display area.
8. Click Display Properties.
The associate table properties appear.
9. Click in the desired field and select No display from the Usage field.
Note:  Because you probably would not want to display this common field twice (once for each table), the No display option prevents duplicate fields in this case.
For more information about specifying operations that can be performed on fields, see How You Can Set Display Properties.
10. Click Generate.
The frame is created and displayed in the Frame Editor.