Identifying Unmatched Foreign Key Rows

RI/Edit lets you insert informational lines, with the message EXCEPTION ROW, into a parent table display, which changes the status of that row to E. (One or more Exception Rows can be created.) When scrolling to the Exception Row of a parent table, the dependent tables automatically display the rows that do not match any row in the parent table. This command is active only in synchronized scrolling (SYNC) mode.
carcudb2
RI/Edit lets you use the E line command to insert informational lines, with the message EXCEPTION ROW, into a parent table display, which changes the status of that row to E. (One or more Exception Rows can be created.) When scrolling to the Exception Row of a parent table, the dependent tables automatically display the rows that do not match any row in the parent table. This command is active only in synchronized scrolling (SYNC) mode.
After the E line command is issued, the exception row is absent because it was inserted after the current line of the parent table.
When you scroll down to the parent table's exception row, the first child table shows no data rows, which means that there are no exceptions. Every row in the child table has a parent row. If the second child table shows a row that contains AAAAAD in the FORNKEY1 column and CCC in the FORNKEY2 column, a row matching the foreign keys does not exist in the edit session.
The E command saves time in identifying unmatched key columns that need editing. Use the same screen to insert a new row or edit a column in the parent or child table if necessary.