Add a New Column to a Table

During the creation of a new table or the modification of an existing table, use the following steps to add a new column:

1. Open the Tables window.
2. In the Tables tab, select the record for the table into which the column will be added.
3. Click the Columns tab.
4. In the Columns tab, right-click and select Add New Column. The system displays the first of two dialog boxes to create the new column.
5. Complete the fields of the first dialog box as appropriate. Remember that the convention for the column ID is that it is in upper case and ends in _ID.
6. Click Next. The system displays the second dialog box.
7. Complete the fields of the second dialog box to configure the column as desired.
8. Click OK. The system checks whether the ID exists. If it does exist, an error message will appear. If it does not exist, then a new record will be inserted into this pane.
9. Click the Tables tab.
10. In the Tables tab, right-click the selected table and select Apply Changes. The system adds the column to the table.
11. Click the  icon.