Progress
Results User’s Guide
for Windows
Adding and Removing Tables
To add and remove tables from a query:
- Choose Tables
Add/Remove Tables.
Results displays the Add/Remove Tables dialog box:
![]()
- Add and remove tables as follows:
- When you are done adding tables to and removing tables from the query, choose OK.
Results displays the Add/Remove Fields dialog box, so you can add or remove display fields. Note that when you remove a table, Results automatically removes the display fields associated with the table.
- To add a display field, select the field from the Available Fields selection list and choose the Add button.
- In the Selected Fields selection list, the fields are listed in the order they will be displayed in the query view (from left to right). To reorder the display fields, select a field and choose either the Move Up or Move Down button.
Select the fields, then choose Add to include them in the layout. Notice that the field list includes not only database fields, but also includes any calculated fields you defined for the query. Use the Move Up and Move Down buttons to position the order of the fields in the layout:
![]()
If you want to include information in a calculated field, but did not create the fields before accessing Label view, choose Field
NOTE: Because the Form view lets you change the position of the fields by dragging the fields in the display, the Move Up and Move Down buttons do not change the position of the fields. They simply change the tab order for the fields.Add Calculated Field from the menu bar, then create the field. Results inserts the calculated field in the label layout at the cursor position. For information about creating calculated fields, see the "Creating Calculated Fields" section in Analyzing Data."
- Choose OK to save your modifications to the query.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |