To choose fields for a query on the database tables
-
Select Database Tables on the Welcome tab.
A list of product lines appears in the Product Lines/System Codes/Files column.
- Double-click a product line to display the system codes.
- Double-click a system code to display the associated database tables.
- Click a table name. The fields associated with that table appear in the Fields list.
-
Selecting fields for the query can be done in several
ways:
-
To select one field, double-click it or drag it to the Selected Fields column.
-
To select multiple fields, click the fields you want, and then drag one of the fields to the Selected Fields column. All selected fields move as you drag.
-
To remove a field from the Selected Fields column, select it and click Remove Selected Field.
- To remove all fields from the Selected Fields column, click Remove All Selected Fields. The message “Are you sure you want to remove all of the selected fields from the list?” is displayed. Click Yes. Selected Fields column is now empty.
To change the order in which fields appear, select a field name and then click the position in the list where you want the field to appear.
-
- If you want to preview the worksheet, you can click Finish to check whether you are getting the data you want. You can also click Finish on any other tab as you build the query. If you have skipped any required fields on previous screens, you will see a message that tells you which selections you must make.