Check FK/PK Values

The Check FK/PK Values utility is a diagnostic tool for system administrators that can be helpful in understanding the Jenzabar SONIS database structure and in solving orphaned data errors. To use the utility, enter a primary key table in the PK Table Name field and a matching primary key column in the PK Column Name field. Then enter a foreign key table in the Foreign Key Table Name field and a foreign key column in theForeign Key Column Name field. If these values are correct, a message will display noting that two combinations match.

If the two pairs do not match or the values are not found in the named table, an error message will appear. This can often be solved by adding or removing the missing data to the table using Table Maintenance or another table editing tool. After adding or removing the needed values, try the functional that failed again to make sure that the issue was solved.