Progress
Results User’s Guide
for UNIX
Joining File Information
This section describes how to join files from two different databases.
You can join a file to any file that is related to it from any database. When you select the Join option, you see a list of the related files you can join to your file.
NOTE: For information on establishing join relationships for files, see Database Administration."Follow these steps to join files from two different databases:
- Select the query form for one of the files you want to join.
- Select the Join option.
Suppose you want to see the orders for Second Skin Scuba, and you know this information is contained in the order file in the sports1 database. After you select Join, you see a list of the files related to the customer file.
For example, the following window shows files you can join to the customer file:
![]()
- Select a related form.
The first record related to the customer file appears:
![]()
Notice that the title at the top of the order form tells you that this is a subset of the records in the related file. When you do a browse of this set, you see the subset of records from the file. In this example they are a subset of records in the order file in the sports1 database, so a browse shows the subset of records from the order file in the sports1 database. In this case, you only see the orders for customer number 1.
Suppose you want to join to another file. For example, you want to see the order-line information for this order. You need to join to the order-line file.
- Select the Join option.
A window appears with a list of the files that you can join to the order file.
- If you join the order-line file from the sports1 database, you see this screen:
![]()
The order-line window displays the first order-line for Lift Line Skiing’s order number 6. Notice that window headlines indicate whether you are looking at a full set of records or a subset.
When you are looking at a subset and you select the Browse option, you see a list of order-lines for order number 6 only. You can select the Browse option to display a summary list of all order-lines for this order, or you can select the Total option to find the total number of order-line records for this order.
Remember, browse lists often show summary information about the records in the set. That is, they show some of the fields in the record. In this case, the browse list shows all the fields in the order-lines for Lift Line Skiing’s order number 6.
If you want to create a report based on file information in these forms, you can exit the Query module, enter the Reports module through the Main Menu, and select the files and fields for your report. However, it is easier to use the Module option to transfer the selections to the Reports module.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |