Update Target Table

Whenever a section data table in a data entry window contains columns with calculated values or values derived from data in other tables, then the Update Target Table command is available. This command allows you to select columns to update and recalculates the values or retrieves the values from the source table for existing records and non-location reference data columns.

1. Select Update Target Table

2. Select the columns to update using the check box in the Select column

   Note: Only data for the currently selected data set is updated. In other words, any filters that may have been set determine what data is updated.
   1. To select more than one column, hold down CTRL while clicking the check boxes of additional columns
   2. To select a block of adjacent rows, select the check box of the first row, hold down SHIFT, and then select the last row of the block
   3. To select or deselect all columns, right-click and use the Select All or Deselect All command
   4. To further restrict what columns and data is updated, you can include a Where clause
3. Select OK and the selected calculated columns are updated using the current data from which it is calculated