It looks not wrong, but do you set the join field in both tables as unique?
You will need to explain further. It's very hard to understand what you're talking about.
Almost always, "Table A, Table B" type descriptions should instead use real-world terminology describing what they are about. Attaching your file or a clone of your file might also help. Your description of key fields sounds random.
The search is returning results based on your design.
Thanks both for your responses. I believe my table and relationship design was sound. The problem resolved when I exported the data and re-imported into a new table to replace the old one. I did this operation for another reason but ended up solving the issue in the process. I believe that the root cause was perhaps using different field types (text field relationship with numerical field) or some sort of data issue. Once the two tables were speaking the same language in that relationship, all the searches returned the expected results.
Thanks again and please forgive if my initial explanation was not useful in helping you help me.