I took a look at this and - success!
I had it set up to match values from [Text ID#1, aka search terms] to the values in [product code field, aka target field]
I corrected it to match [Text ID#1] to the field [Master Table: Search Table - Text ID#1]
This was your initial suggestion. I had assumed this was a suggestion for the table relationship and was confused. Now I understand this is the field relationship between two already related tables.
I am now able to search for hundreds of items at a time in a user friendly way .Thank you very much for the help. This will save me time and drive user adoption.
