Linking 3 Fields in Main Table to Single Field in Refernce Table

[isorders]

I have a primary table that has OwnerID, PreviousOwnerID and NewOwnerID. I then have tblOwner that has OwnerID, FirstName, LastName, etc.
I can't figure out how to join the OwnerID from tblOwner to PreviousOwnerID, OwnerID and NewOwnerID in the primary table. For reporting purposes I need to pull the Last Name, First Name for each field from the tblOwner.
This may not be the best way to do this, but I want the Owners Names to be consistent and creating three reference tables seems redundant.

 

[KenReay]

Hi

In the query design grid, add the tblOwner three times (access will automatically give the two occurences after the first one aliases, tblOwner_1, tblOwner_2

Make a join form first owner field in main table to first tblOwnwer, then from secon Owner field in main table to second owner table, etc

You may need to right click on joins and set accordingly since I assume not very row in main table has all three owners present?
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use