Hi all,
I am having a problem with a lookup table in my query. I have table added that contains 20 columns with code values. I am trying to link those column values to a lookup table to return the real value for a report.
The problem I am having is that in order to get the correct values to return in the query I have to add the lookup table 20 times and create a one->many link from each colum value to my lookup tables. This locks the query up if I specify more than a few records. I have tried adding the lookup table once and joining each column value to lkup but this returns blank cells. What I am doing wrong? It is possible to set the lookup in the report instead?
I am having a problem with a lookup table in my query. I have table added that contains 20 columns with code values. I am trying to link those column values to a lookup table to return the real value for a report.
The problem I am having is that in order to get the correct values to return in the query I have to add the lookup table 20 times and create a one->many link from each colum value to my lookup tables. This locks the query up if I specify more than a few records. I have tried adding the lookup table once and joining each column value to lkup but this returns blank cells. What I am doing wrong? It is possible to set the lookup in the report instead?
