Managing the Database : Using Data Modification Utility : Moving Facility Records
   
Moving Facility Records
Information in this section explains how to move facility records from one ROW to another ROW.
Complete the following steps:
 
1 Click Tools > Data Modification Utility to open the Data Modification Utility window (Figure 18-6).
Figure 18-6. Data Modification Utility - Facility
2 Select a ROW in the top Select ROWs panel that will be moved to another ROW. This is the source ROW.
3 Select a ROW in the lower Select ROWs panel where the records will be moved. This is the target ROW. The records from the top panel are moved to the ROW selected in the lower panel.
Note: You cannot select the same ROW that was selected in the top panel.
4 Select the facility type(s) you want to work with using the method described in either step a or step b:
a To select a facility type, click the facility type option button and then click the down arrow and select a facility type in the list, such as [PCS] Rectifier Survey (Figure 18-7).
Figure 18-7. Facility Type Theme Option
b To select multiple facility types, click the Ad Hoc Theme option button and then click the check box for one or more facility types, such as Test Point, Rectifier, and Foreign Bond (Figure 18-8).
1) Click Select All to select all the facilities. Click Clear All to clear all facilities.
Note: An Ad Hoc Theme only applies to the current session and is not saved. A facility type is selected when a check mark appears inside the check box. To clear the check mark, click the check box again.
Figure 18-8. Ad Hoc Theme Option
5 Click the Select ROWs and Facility Types bars to close these panels (Figure 18-9).
Figure 18-9. Facility Move Panels
6 To customize the layout of the facility move panels, click Customize.
a Add or remove fields as desired.
b Click OK to save changes and close Edit Layout dialog box.
7 Move records from the top panel to the lower panel in any of the following ways:
a Double-click the name of the record.
b Click the check box next to the name of the record.
c Click Select All to select all the records.
The records are moved to the lower panel and are highlighted in green (Figure 18-10).
 
Figure 18-10. Moved Records
8 Move records from the lower panel back to the top panel in any of the following ways:
a Double-click the name of the record.
b Click the check box next to the name of the record.
c Click Select All to select all the records.
d Click Clear All to clear all records.
The records are moved back to the top panel and are highlighted in green.
9 To save the changes and permanently move the records, click Apply.
10 Click Yes in the Warning dialog box (Figure 18-11) to complete the move.
 
Figure 18-11. Warning Message