Previous Topic

Next Topic

Table Editor

Navigator > Setup > Table Designer > Table Editor

You can edit tables created in Table Designer. This is raw data entry and the data is not validated against the record. Table Editor can be used to add a few lines (or similar) to an existing custom table, to save considerable time.

Open File(s) (Ctrl+O)

Open a custom table.

Quit Application (Alt+F4)

Close the Table Editor.

Grid Toolbar

ToolbarExpand

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Edit (F11)

Edit the Table.

Insert (F4)

Insert a new record at the selected line.

Move (Shift+Up) (Shift+Down)

Select a field and reorder the list.

Delete (F3)

Delete the selected record.

Open (F12)

Open the record in form view.

Print (Ctrl+P)

Print a report of records in the table.

RecordFilterSort_Hot

Filter / Sort List (Ctrl+F2)

Clear Filter / Sort (Ctrl+F3)

Apply or clear a Filter & Sort. The button changes to indicate if a filter and sort is applied.

Customise (Alt+F5)

Opens Customise Fields, you can customise the fields visible in the grid.

Refresh List (F5)

Updates records listed with changes made by other users or in other forms.

Utility

Utilities (Alt+U)

You can select to:

  • Edit Controls
  • Rebuild Table
  • Reclaim Table
  • Optimise Table - see also Optimise Tables.
  • Link to Master Table
  • Set Variant Field Type
  • Prevent Record Appends
  • Delete All Records

Save the changes (F9)

Save any changes made.

Cancel the changes (Esc)

Cancel any changes made.

Copy record to clipboard

Copy the selected record to the clipboard.

Paste record from clipboard

Paste a record from the clipboard to the Table Editor.

Automation Help

Display documentation for the table.

See Also

Table Designer

Book Contents

Book Index