Progress
Results User’s Guide
for Windows


Adding and Removing Tables

To add and remove tables from a query:

  1. Choose Tables Add/Remove Tables.
  2. Results displays the Add/Remove Tables dialog box:

  3. Add and remove tables as follows:
    • To add a table, select the table from the Available Tables selection list and choose the Add button.
    • To remove a table, select the table from the Selected Tables selection list and choose the Remove button.
  4. When you are done adding tables to and removing tables from the query, choose OK.
  5. 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.

  6. To add a display field, select the field from the Available Fields selection list and choose the Add button.
  7. 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.
  8. 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 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."

    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.

  9. 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