Selecting columns for a view
Each row in the column represents a row in the new view.
- 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.
- To change the order of the columns in the view, you can drag and drop rows by dragging the first column in the grid.
- You can edit any field in the selection grid except the Group field.
- 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:
- Establish some selection criteria
- View or edit the SQL used to create the view
- Create a formula from two or more of the columns
If you want to do none of these things, click OK to create your new view.