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
  Designers make it possible for you to design the windows, dialog boxes, and components in your application visually.
• Class Designer
  Use the Class designer to create and modify classes visually.
• Connection Designer
  Use the Connection designer to create and modify named connections. Because connections are stored as part of a database, you only can use the Connection designer if you have a database open.
• Data Environment Designer
  Use the Data Environment designer to create and modify the data environment of forms, form sets, and reports visually.
• Database Designer
  The Database designer displays all the tables, views, and relationships contained in a database.
• Form Designer
  Use the Form designer to create and modify forms and form sets visually. A form set consists of one or more forms that can be manipulated as a unit.
• Label Designer
  Use the Label designer to create and modify labels. When the Label designer window is active, Microsoft Visual FoxPro displays the Report menu and the Report Controls toolbar.
• Menu and Shortcut Designers
  Use the Menu designer and the Shortcut designer to create menus, menu items, submenus of menu items, lines that separate groups of related menu items, and so on.
• Report Designer
  Use the Report designer to create and modify reports. When the Report designer window is active, Microsoft Visual FoxPro displays the Report menu and the Report Controls toolbar.
• Table Designer
  Use the Table designer to create and modify database tables, free tables, fields, and indexes.