(Contents)

Using the Column Form

See also:


What do you want to do?


Finding and Displaying Records in the Column Form

To find a record in the Column form:

  1. If applicable, in the Column form's Start at and Finish at fields, enter the range of records to search for and select the Sort button

    The Select Item From List form is displayed, on which you nominate a field to be the sort 'key', and the column form redisplays with the first record in the range.

  2. If required, select the Next button

    The next record is displayed.

  3. If required, select the Previous button

    The preceding record is displayed.


Sorting Records on the Column Form

See also: Sorting records on the Grid and Column forms.

To sort records in the Column form:

  1. On the Grid form, select the Column button

    The Column form is displayed.

  2. Select the Sort button

    Tip: To sort a range of records, before you select the Sort button, enter a value in the Start at and/or Finish at fields. The values you enter must relate to the key path (sort field) you subsequently select.

    The Select Item From List form is displayed, enabling you to select a key path.

  3. Select a key path and select the OK button

    The Select Item From List form closes and the grid form displays the first record in the range.

  4. Select the Next and Previous buttons to display additional records

    Additional records are displayed.


Creating Records in the Column Form

To create a record in the Column form:

  1. On the Column form, select the Create button

    A new blank record is displayed.

  2. Left-click in the first field of the new record

    A text cursor is displayed in the field.

  3. Complete each field of the record, using the TAB key to move to the next field or left-clicking in the field

  4. Select the Save button

    The new record is saved to the file.


Amending Records in the Column Form

To amend a record in the Column form:

  1. If applicable, in the Start at and Finish at fields, enter the range of records to amend and select the Sort button

    The Select Item From List form is displayed, on which you nominate a field to be the sort 'key', and the column form redisplays with the first record in the range.

  2. Left-click in the first field of the record to edit

    A text cursor is displayed in the field.

  3. Edit fields of the record, using the TAB key to move to the next field or left-clicking in the field

  4. Select the Save button

    The edited record is saved to the file.

  5. Select the Next button

    The next record is displayed ready for editing -- refer to step 2.

  6. If required, select the Previous button

    The preceding record is displayed ready for editing -- refer to step 2.


Deleting Records in the Column Form

To delete a record in the Column form:

  1. If applicable, in the Start at and Finish at fields, enter the range of records to see and select the Sort button

    The Select Item From List form is displayed, on which you nominate a field to be the sort 'key', and the column form redisplays with the first record in the range.

  2. Select the Delete button

    The record is deleted from the file and the next record is displayed.

  3. If required, select the Next button or the Previous button

    The succeeding or preceding record is displayed, respectively.


Column Form

This is displayed when you select the Column button on the Grid form. It displays individual records in a single column table format.

Tip: To switch between Grid form and the Column form, select the Column button and Grid button, respectively.

Reverse: A tick indicates that, when you select the Sort button, the form redisplays with records in descending order

Start at: Restricts the range of records displayed to those whose key field value is equal to or greater than the value entered into this field

Finish at: Restricts the range of records displayed to those whose key field value is less than or equal to the value entered into this field

Tip: Select the Sort button after editing the Start at or Finish at fields.


Buttons:

Ad-hoc: Displays the Ad-hoc enquiry form, enabling you to construct queries and display, print, or graph the result

Grid: Rearranges the form into grid format.

Sort: Displays the Select Item From List form, on which you nominate a field to be the sort 'key', and the grid form redisplays with the records in sorted order. See Sorting Records.

Create: Displays a blank record ready for you to enter new field values.

Delete: Deletes the displayed record.

Cancel: Abandons a creation, amendment, or deletion.

Save: Saves a newly created or an amended record.

Next: Displays the next record in sequence, depending on the sort method chosen.

Previous: Displays the previous record in sequence, depending on the sort method chosen.


Related Topics:

Amending records

GEDIT Form

Grid Form

Sorting Records on the Column Form

(Contents)(Top of the Page)