Edit Records

On the File | File Editor tab, in the Edit Records group:

• Click Insert One (CTRL + I) to insert a single blank record.

  

• Select Insert | Insert Many to insert a number of blank records.

• Click Delete Records (CTRL + D) to remove one or more records from a file.

• Click Delete Rows (CTRL + DEL) to delete the current row or selected rows in the Editor. There is no warning prior to the deletion, but you can undo.

• Click Ditto to copy the contents from the cell above the current cell to the current cell (CTRL + ').

  

• Use Increment One (CTRL + A) and Increment Many (CTRL + SHIFT + A) to increment field values in successive records of a file.

• Use Replicate One (CTRL + R) and Replicate Many (CTRL + SHIFT + R) to copy the contents of a field to the same field in successive records.

• Use Execute One (CTRL + T)and Execute Many (CTRL + SHIFT + T) to carry out the actions defined for each field in the Execute Parameters form.

• Select Execute Parameters to run (Increment, Replicate, Blank and Copy From) commands on multiple fields at the same time. It also allows you to Hide and Show fields. The configuration can be saved so that it can be re-used at a later date.

The majority of these options are also available on the File | Lookup Table Editor tab, in the Edit Records group for Lookup Tables.