During the creation of a new table or the modification of an existing table you can add an existing column using these steps:
- Open the Tables window.
- In the Tables tab, click the record for the table into which the column will be added to select it.
- Select the Columns tab.
- In the Columns tab, right-click and select Add Existing Column. The system displays a dialog box to enter the ID or label of the column.
- In the dialog box, type the column's ID or label. As you type the system will match what you type with existing column IDs and labels. These potential matches are shown below the field. You may continue typing or click the potential match that you want.
- Click OK.
- Select the Tables tab and right-click the selected table. Select Apply Changes. The system adds the column to the table.
- Click the icon.