Unanswered: Losing lookup information in a union query
I have a table that has a number of lookup fields. These all have the same three-column row source but I only display the values from the middle one by setting the other two column widths to zero. The first column is the foreign key and the third is a column that I filter by. I have a union query that includes all of these lookup fields in the same column. The problem is that in the results of the union query I lose the looked-up values and just get the foreign key returned. Any ideas? (Or any better ways to get the same information?) All answers extremely gratefully received!