Manage Data
Users are allowed to edit the extended information of the existing data within the database SC and FT tables.
By selecting the Manage Data tab, a list of all SC and FT tables are listed. Each Table represented in this list shows the number of records that exist within each table.
Once a table has been selected from the list, the records for that table are displayed in the data grid provided.
If the user selects a row in the data grid, a list of the un-editable Default Codes for that record are displayed under the list of tables.
If the table selected is extended beyond the default codes, selecting a record from the Feature Table View will display a Drop Down list to choose values from and/or Text Boxes to modify the extended data from the selected record.
The controls provided for data manipulation are color coded to inform the user of required fields and what is not required and will only accept numbers.
Update
Once the required changes are made, the user can either update an existing record, with the values provided into the database.
Add
To Add a new record to an FT table that has been extended, The user will press the Add New button provided at the bottom of the View/Edit tab.
If the user has selected more than one Alignment from the list of available Alignments, a form will appear requesting the user clarify which Alignment the new FT table record data will be attached to.
Once an Alignment assignment has been made or only one Alignment has been selected by the user, a form will be displayed allowing the user to enter or select the data for the new record. Only the extended columns of the selected FT table are available for the user to modify.
If the FT table type is set to POINT, the required Fields for the user to enter are:
- Station
- Measure
If the FT table type is set to LINE, the required fields for the user to enter are:
- Begin Station
- Begin Measure
- End Station
- End Measure
If the Ft table has been extended, the user is allowed to make edits to the extended columns of the FT table, on the right side of the form.