we have a list with a list of employees. the PK is the employee ID. We have a second list where one column is employeeId, and it looks up to the first list. the default view on the employee list applies a filter to show only active employees.

the employee list has a record where the PK is 'disalvo'. this record does exist, but that employee is inactive, so that record is not present in the default view. the second list has a record where 'disalvo' is used. This shows up like a broken lookup. The only explanation I can see would be that disalvo isnt part of the default view. however, this row does exist and that lookup should not behave like it cannot be resolved.

this seems like a bug to me.