Query Select Tables

The Query Designer form Tables section allows tables containing FH data to be added to the query.

  1. From the Tools menu, select the Queries... option.

    The Queries form is displayed.

  2. Select the module and record area, and either create a new query, or modify an existing query.

    Information on creating or modifying a query is available in Create New Query and Modify Query.

  3. Verify that Report is selected for Query Type(s) for the query.
  4. Click the Tables tab to display the Tables section.

    All available tables are displayed in the left box. The right box lists the tables selected to be included in the query.

  5. To add a table, highlight the available table name in the left box, then double-click or press , and the table will be added to the selected tables.

    When you add a table, all fields in the table will be available for adding to the query in the Fields section.

    Note: When you add multiple tables, the tables need to have a common field to relate the records in the two table together. FH attempts to determine the proper fields to “join” the tables on. You should check all joins for accuracy, as improper joins will create invalid query results.

  6. (Optional) Display table properties.

    1. Highlight the table name listed in Selected Tables, then press Properties....

      The Query Table Properties form is displayed.

      Property Does this

      Table Source 

      Lists the name of the database and table using the format:

      DBC Name!DBF Name

      where DBC Name is the name of the database (the .DBC extension is not included) and DBF Name is the name of the table included in the DBC (the .DBF extension is not included).

      Note: You cannot modify this field.

      Local Alias 

      By default, lists the name of the table. This name is used throughout the query when fields from the table are used.

      You can modify the value if necessary.

    2. Press OK to exit this form.

 

Related Topics: