Adding and Removing Fields

Fields can be added or removed from the list of available fields. This is needed if fields are created or deleted from the physical database table.

To add a field to a table:

  1. From the Tools menu, choose Data Editor.

  2. In the Actions column next to the table you want to edit, click the Edit icon. This displays the Table Configuration opened to the General tab.

  3. Click the Fields tab. This displays all the fields currently available in Data Editor for the table.

  4. Click the Add field toolbar button at the top of the page. This displays the Add Field dialog.

  5. Select the fields that you want to add to the table and double click the Move to Selected icon to select them.

  6. Click Save when you are done.

  7. The field is now displayed on the Fields tab and can be configured.

To remove a field from a table:

  1. In the Actions column for the field, click the Delete icon. This displays a dialog confirming that you want to delete the field.

  2. Click Yes in the prompt.

This removes the field from the table in Data Editor.

You can restore any field that you have deleted by following the steps above for adding a field to a table.

Related topics

Viewing and Editing Table Data

Adding and Deleting Records

Filtering and Sorting Records

Modifying General Table Properties

Setting User Security on Tables and Fields

Formatting Fields

 

 

_____________________________