Multiple relationship betwen 2 tables how to force a query to use a specific one

[blackwolf23]

I have 2 relationships between 2 tables .First table is called "Personnel" the second one is called "Equipment". "Personnel" has 2 connections to "equipment". One being the person who rented it and a second one being the person who added the equipment.
Every time I try to make a query about the person who has the equipment and ask for a name and last name it always shows me the person who added it to me.How do I fix this ?

 

[Ranman256]

Your query must pull the tEquipment.RentorID
(Not tEquip.RentedID)

 

[blackwolf23]

Your query must pull the tEquipment.RentorID
(Not tEquip.RentedID)

Well I know it should but i dont know how to achieve that........

 

[pbaldy]

In the query, add the personnel table twice. Join each of the two fields in equipment to a different instance of personnel.

 

[blackwolf23]

In the query, add the personnel table twice. Join each of the two fields in equipment to a different instance of personnel.

It works! Thank you a lot man! I have been grinding my teeth with this error for a good 2 hours.

 

[pbaldy]

Happy to help!