Jerrry, The fact tthat one of my tables has a space between the ID and the number is simply a careless oversight. There are no letters in any of my table, just numbers. I will try your answer tomorrow and return to this page if it works. If not, I'll be back to ask you more about it. And, of course if it works, I'll check that you solved my problem.
Apparently you didn't like my Codes and IDs. No matter how you approach this, you will have to mind the details. If you look for "ID 476", "ID476" won't be a match.
You will, of course, have to substitute your specific table names and data for what I used in my example.