Selecting and sequencing fields in a view

The order in which fields are displayed in a view is initially drawn from the underlying template. However, you can modify the field sequence in your view and exclude fields from display. Fields excluded from display can still be used in layout identification or field selection criteria.

To change the order in which fields are displayed when browsing or editing the database:

  1. On the View : Segment Layout panel, enter a sequence number in the Seq fields.

    Fields with sequence numbers are displayed before fields without sequence numbers. Fields with sequence numbers are displayed in the relative order of the sequence numbers. The remaining fields (without sequence numbers) are displayed in their default order (the order in which they appear in the panel). Sequence numbers do not need to start at 1, or be consecutive.

To exclude a field from a layout:

  1. On the View : Segment Layout panel, enter an S in the Cmd field adjacent to each field that you want to include.

    The S command toggles the selection on or off, depending upon its current status. An 'S' is shown in the SHC column for each field that is selected.

Note: Field selection differs from segment type or layout selection, in that all fields are selected by default. Therefore, if no selection is made in this panel, and no field is tagged with an 'S' in the SHC column, all fields are selected. However, as soon as you tag one field with the S command, all other fields become excluded.

When there are a large number of fields in your layout and you only want to deselect a few, you can tag all the fields for selection in one action, and then deselect only those you want to exclude. To do this:

  1. On the View : Segment Layout panel, enter the SELECT ALL primary command in the Command line.
  2. Enter the S command in the Cmd field adjacent to each field that you want to exclude.

Related topics