"Buster Chops" wrote
Table 1 has two columns, A and B. Column
A is the Key ... column B is the name-value.
Table 2 has many rows and has 10 Columns. Each
column contains a value which I need to look against
Table 1 Column A and retrieve the Table 1 Column B
name-value.
Piet's reply tells you how to do this with your current design, but almost
certainly your design should be "normalized" to comply with relational
database design principles. It appears you have 10 Columns, each
representing the same type of information. If those were each separate Rows
(Records, in Access Terms), you could simply query to find what Key values
have a particular name-value. As it is, such a question is likely to require
a laborious query structure to answer.
Larry Linson
Microsoft Access MVP
And I cannot seem to do this without laborious and repeated queries. Any
tricks?