Selecting columns for a view

Each row in the column represents a row in the new view.

  1. To choose the columns that you want in the new view, click on them in the selected tables and drag and drop them in the selection grid on the bottom half of the dialog. A dragged column is inserted in the row above the cursor. To insert a column at the bottom of the grid, drag the column after the last row in the grid.
  2. To change the order of the columns in the view, you can drag and drop rows by dragging the first column in the grid.
  3. You can edit any field in the selection grid except the Group field.
  4. To remove a column from the selection grid, select the column and click Delete to remove the row indicated by the arrow.

Notes: If you want to include all or most of the columns from one table in the view, you can drag a table from the Browse Tables dialog and drop it in the selection grid. All the columns in the table will be added to the selection grid, and the table will be added to the work area. If all columns are in the select list, the select list will be *. Changing a column name results in a new column list.

If you selected more than one table or view, you must define a join relationship . If you selected only one table or view, you can now:

If you want to do none of these things, click OK to create your new view.