Clicking on a record in a list gives a record not found error
Overview
The most likely cause for this issue is that there is a dictionary record in the table (or a parent table) that is a reference field but has not table defined in the Reference field.
Heading
You should be able to correct this issue by reviewing the dictionary for your table and the associated parent tables for any fields that are reference type and have no value. This would mean taking the following steps:
- Go to System Definition > Dictionary.
- Set your filters as follows:
Type is Reference
and
Reference is empty
You can also enter the URL directly as follows:
../sys_dictionary_list.do?sysparm_query=internal_type%3DReference%5EreferenceISEMPTY - If any records are displayed then you should update the Reference field with the correct table that the reference should be pointing to.
If records were found then correcting them should resolve your issue.