multiple fields in 1 table joined to 1 field in a 2nd table

[krberube]

I have not run into this before, and hope there is a solution out there.
Table1 contains 6 fields - fail1, fail2,....fail6
Table2 contains 2 fields - Code, Description
I want my query to JOIN on fail1, fail2..... to CODE and have the 6 different descriptions show in my query output.

I can create the joins to CODE, but can't get the Description to show 6 times.

I hope I explained this correctly.

Any Ideas?
Thanks
Kevin

 

[GabrielR]

You can just import the 2nd table as many times as you need it in the query screen and do the join for each field.... But, I think that the real problem is Normalization Here, for that type of Operation there shoud be a table with three columns:

Table 1:

Id------FailNumber------FailCode

Table 2:
Id------FailCode------FailDescription

That way you will only need to to the Join once and query the entire table.

I have learnt that when you have a table that list

Fail1---Fail2---Fail3---etc.... maybe you have a normalization problem there...

 

[krberube]

That makes sense. Thanks!