Query and View Designers

To create and modify queries and views, use the Query Designer and View Designer. When the Query or View Designer is active, the Query menu and the Query Designer or the View Designer toolbar are visible.

The top pane of the designer displays the tables in the query or view. A resizable window representing each table lists the fields and indexes in the table. The designer shows join conditions by displaying lines that connect fields between tables. You can drag indexed fields between tables to create join conditions. To display the Join Condition Dialog Box for editing the condition, double-click a line.

In This Section

• Fields Tab, Query and View Designers
  Specifies fields, aggregate functions, such as SUM Command or COUNT Command, or other expressions.

• Join Tab, Query and View Designers
  Specifies join expressions for matching records between two or more tables or views.

• Filter Tab, Query and View Designers
  Specifies conditions for selecting records, such as specific values in a field, or join conditions defining temporary relationships between tables.

• Order By Tab, Query and View Designers
  Specifies fields, aggregate functions, such as SUM Command or COUNT Command, or other expressions used to set the order of records retrieved in the query.

• Group By Tab, Query and View Designers
  Specifies fields, aggregate functions, such as SUM Command or COUNT Command, or other expressions used to combine records into a group based on identical values in those fields.

• Update Criteria Tab, View Designer
  Specifies fields to be updated and criteria for fields to be updated (View Designer only).

• Miscellaneous Tab, Query and View Designers
  Specifies if duplicates should be retrieved and limits on records, such as the top quantity or percentage.

Related Sections

• Designers
  Provides information about Visual FoxPro designers, which make it possible for you to design windows, dialog boxes, and components visually for your application.