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.
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_Location_MSTR
SV_Equipment_MSTRSV_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.
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.