Page History

Follow these steps to To create a new table that contains location data, follow the steps below:

1. Open the Tables window.
2. In the Tables tab, right-click and select Insert. The application displays
   This opens a dialog box.
   • For the purposes of this example,
   assume that
   • the table does not yet exist in the database.
   Therefore
   • 
     In which case, in the Insert dialog box, click the radio button beside New.
3. Click the arrow for to open the drop-down list and select Location.
4. Enter the internal name of the new table in the text field in the lower part of the dialog box.

5. Click OK

   . The application

   
   This closes the dialog box and adds a new record to the table

   . (

   Info
   Note: The table is not actually created in the database

   at this point

   yet.

   )

   Image Modified

6. In the new record, enter the name of the new table in the Table Label column and, optionally, any additional information in the Comments column.
   Image Modified
7. Click the Columns tab . This tab shows to display the default columns for any table (comments, user ID, and user update date).
8. Right-click the table in the Columns tab and then select the appropriate command: either
   
   • Add New Column if the column does not exist in the
   database or
   • database 
   • Add Existing Column if the column does exist
   .
   • 
     Image Modified
9. Repeat the previous step 9 for each column.
10. If desired, click the Index tab and create an index for the table. See How to
    Please read Create an Index for the a Table for more information.
11. Select the Tables tab.
12. Right-click the record for the new table and select Apply Changes. The application now
    This creates the table in the database with the columns specified in the Columns tab.
    Image Modified
13. Click the Image Removed icon. Save

The table is now created. Next you will need to create the window for the display of data from the table. Three general types of windows may be created: one that displays data in a tabular format (See Make a Data or List Window); one that displays data graphically along a route, provided location information is in the database table (see Make a Graph Along-the-Route Window); and a pop-up window that is launched by hyperlinks in a column (see How to Make a Popup Window).