Check Links Utility

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.

Select Signature Utilities > File Maintenance Utilities > Service Management > Check Links.

Select the table you want to check in the Tables scrolling window and select 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_MSTR
SV_Maint_MSTR	SV_Location_MSTR
SV_Service_MSTR	SV_Customer_MSTR

Select Preview to view the missing or damaged records. An error log report prints.
Select the Check Links button to begin the process. You will receive a message asking if you want to continue. Select Continue.
You will receive a message when the Check Links utility is complete. Select OK.

Service Management also has a Check Links process that checks specific links. See the Utilities section in the Service Management User Manual for more information.