I have three tables - I'll call them TableA, TableB, and Corrections (the actual names and data would take too long to explain). TableA contains handkeyed data, including a "TableBValue1" field which is a foreign key used to link to TableB.
The problem is that the data entry folks consistently miskey certain "TableBValue1" entries (and I can't correct that root issue at this time). So I have a Corrections table with two fields: "MiskeyedTableBValue1" and "CorrectTableBValue1". Kind of like an AutoCorrect table.
QUESTION: How do I now write a query to link TableA to TableB on that "TableBValue1" field, but checking the Corrections table first? I thought about trying to write a Union query to join those TableA records with a "TableBValue1" match in Corrections to those TableA records with no match, then link that composite table to TableB. But I'm not sure how to do that...
VBAjedi![[swords] [swords] [swords]](/data/assets/smilies/swords.gif)
The problem is that the data entry folks consistently miskey certain "TableBValue1" entries (and I can't correct that root issue at this time). So I have a Corrections table with two fields: "MiskeyedTableBValue1" and "CorrectTableBValue1". Kind of like an AutoCorrect table.
QUESTION: How do I now write a query to link TableA to TableB on that "TableBValue1" field, but checking the Corrections table first? I thought about trying to write a Union query to join those TableA records with a "TableBValue1" match in Corrections to those TableA records with no match, then link that composite table to TableB. But I'm not sure how to do that...
VBAjedi
![[swords] [swords] [swords]](/data/assets/smilies/swords.gif)