Page History

...

• Location data
• A list used for setup
• Inventory data.

To create this type of a General table, use the following steps:

1. Open the Tables window.
2. In the Tables tab, right-click and then click click Insert. The application displays a dialog box.
3. For the purposes of this example, assume that the table does not yet exist in the database. Therefore, in the Insert dialog box click the radio button beside New.
4. Click the arrow for the drop-down list and then click General.
5. Enter the internal name of the new table in the text field in the lower part of the dialog box.
6. Click Click OK. The application closes the dialog box and adds a new record to the table. (The table is not actually created in the database at this point.)

Image Added

1. In the new record, enter the displayed name of the new table in the Table Label column and, optionally, any additional information in the Comments column.

Image Added

1. Click the Columns tab. This tab shows the default columns for any table (comments, user ID, and user update date).
2. Right-click the table in the Columns tab and then select the appropriate command: either either Add New Column if  if the column does not exist in the database or or Add Existing Column if  if the column does exist.

Image Added

1. Repeat step 9 for each column.
2. Click the Index tab and create an index for the table. See Create an Index for a Table for more information.Click the Tables tab.
3. Right-click the record for the new table and then click click Apply Changes. The application now creates the table in the database with the columns specified in the Columns tab.

Image Added

1. Click the Image Removed iconSave button.

1. The table is now created. Next you will need to create the window for the display of data from the table. See Make a Data or List Window for more information.