Answer
Check whether the key list for that lookup selects only the identifying field you prompted for, without the other fields (like a select clause) needed to disambiguate between similar records — under-specifying the lookup's keys/select list is a common cause of quietly retrieving an unintended record instead of failing loudly.