This utility checks the links between certain tables. If information in one table is missing or damaged, this process examines other tables where the same information is stored.
If a missing or damaged record is found, the remaining data or records will be deleted so you can manually re-enter the damaged data.
Note: Back up the entire folder containing the tables to be checked before performing this process.
- Choose Signature Utilities > File Maintenance Utilities > Service Management > Check Links.
- Select the table you want to check in the Tables scrolling window and choose Insert >> to insert it in the Selected Tables scrolling window.
The following tables are checked:
Table: |
Check links with: |
SV_Contract_Billing_MSTR |
SV_Maint_MSTR |
SV_Customer_MSTR |
RM_Customer_MSTR |
SV_Equipment_MSTR |
SV_Location_MSTR |
SV_Location_MSTR |
SV_Customer_MSTR |
SV_Maint_Annual_MSTR |
SV_Customer_MSTR |
SV_Maint_MSTR |
SV_Location_MSTR |
SV_Service_MSTR |
SV_Customer_MSTR |
- Choose Preview to view the missing or damaged records. An error log report prints.
- Choose the Check Links button to begin the process. You will receive a message asking if you want to continue. Choose Continue.
- You will receive a message when the Check Links utility is complete. Choose OK.
Note: Service Management also has a Check Links process that checks specific links. See the Utilities chapter in the Service Management User Manual for more information.