Step 1 Create the first query

Step 1. Create the first query

You will start with a query using the Product file, so that you can see all the products that are available.

1.  To create a new query, select the File and choose the New command. Alternatively, you could select the associated icon on the Tool Bar or use the accelerator keys (Ctrl + N).

     When a new Query window is displayed, the:

• Selected File area shows you all the files you can access.

• Selected Fields area shows you the fields included in the query. Initially this area will be blank.

• Defined Links to Queries area shows the queries that are linked together. An indented query indicates that it can be called by the query above it. Initially this area will be blank.

2.  In the Selected File area, select the Product file by double clicking on its name.

     Immediately, the fields in the Product file are listed beneath the file name and the Product file's name is inserted into the title bar of the area. This file is now identified as the primary file of your query.

3.  Now go to Step 2. Select the fields for the query.