Display multiple connections between 2 tables in 1 query/report

[MrMode]

I have 2 tables.

Table 1 contains 6 combo boxes that all draw both numeric and text values from table 2.

The value stored in table 1 is the numeric recordid from table 2 not the text.

I want to show all 6 results in table 1 but with the text value not the numeric value from table 2 and am limited to linking only 1 field how do I get the information in to the query?

 

[dhookom]

It sounds like you need to link the lookup table 6 times if each of the combo boxes has the same row source. This suggests an unnormalized table structure.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.