Multiple Lookup

I have a TechFactTable containing the following information --- TechName1, TechName1 ... etc. There are 5 techs assigned to one record for round the clock service. For this fact table that I'm creating, I need to use a TechDimension (TechIDs, TechNames) to create a ID mapping that can be used in the fact table. The fact table needs to use the TechIDs not names.

I'm trying to create, can I set my lookup (ref table = TechDimension) to look up all 5 of these IDs at the same time?

For example,




Code Snippet
[TechFactTable]
TechName1 TechName2 ...
--------- ---------
Obama Clinton


[TechDim]
TechIDs TechNames
---------- -----------------
1 Obama
2 Clinton... ...



So i've set up my lookup query to return the TechDim info using something like




Code Snippet
SELECT T1.TechID AS TechID1,
T1.TechName AS TechName1,
T2.TechID AS TechID2,
T2.TechName AS TechName2
... (etc)
FROM TechDim T1 LEFT JOIN ON TechDim T2 ON T1.TechID = T2.TechID




After this I mapped my columns in the lookup so that I had
TechFactTable TechDim
TechName1 ------> TechName1
TechName2 ------> TechName2

and then return the newly added columns TechID1 and TechID2 but all in the SAME LOOKUP?