Progress
Results User’s Guide
for UNIX


Joining Files

In this section, you join the order file to the customer file so that you can see the orders for Thundering Surf. For information on how to establish join relationships for files, see Database Administration."

  1. Select Browse.
  2. Select the Thundering Surf Inc. record (customer number 16).
  3. Select Join.
  4. A list of the files related to the customer record appears:

    You can join files if they have one field or a number of fields in common.

  5. Select Order to see the order records for customer 16.
  6. The window in the figure below displays a subset of information—default fields from the order file:

    Note the following about the display:

    • There are fewer options on the horizontal menu (the View and Order options are gone) when you are working within a subset of information.
    • The title at the top of the order form indicates that you are in a subset. Therefore, the options that you select will display order information only for the current customer, Thundering Surf.
  7. Select Browse to display a summary list of all orders for this customer:
  8. Press END to exit browse.
  9. Select Total to display the total number of orders for this customer.
  10. This message appears at the bottom of the window:

  11. Press END to exit Total.
  12. To get more information about this order number 23, you join the order-line file to the order file.

  13. Select Join again.
  14. Select Order-Line file.
  15. The following window appears:

    The order-line subset displays the first order-line for Thundering Surf’s order number 23. Because you are in a subset, when you select Browse you see a summary list of order-lines for order number 23. You can select Total to find the total number of order-line records for this order.

  16. Select Total to find out how many order-lines there are for this order.
  17. This message appears at the bottom of the window:

  18. Press END to exit Total.
  19. Select Browse to display a summary list of all order-lines for this order.
  20. Press END to exit this list.
  21. Select Exit twice to exit the order-line subset and the order subset.
  22. This returns you to the original customer record.

  23. Select Exit to return the Results Main Menu.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095