Queries :: Getting Information From One Field To Two Fields

I have a table that contains Investigator1,Investigator2 and other fields

And another table that contains PID, Rank_Name_Family and other fields

I am making a query in that query i want to get the names of Investigator1 and Investigator2

Investigator1 and Investigator2 is the PID

for example

Investigator1 = 1
Investigator2 = 2

PID = 1 Rank_Name_Family= Roy Jalbout
PID = 2 Rank_Name_Family= Rony Jalbout

i tried this two solutions but the result is error

Solution 1

Code:
Name1: DLookUp([Rank_Name_Family];"tbl_Personal_Information";[tbl_Personal_Information].[PID]=[tbl_Driving_Expert].[Investigator1])
Name2: DLookUp([Rank_Name_Family];"tbl_Personal_Information";[tbl_Personal_Information].[PID]=[tbl_Driving_Expert].[Investigator2])

Solution 2

Code:
Name1: DLookUp([Rank_Name_Family];"tbl_Personal_Information";[tbl_Personal_Information].[PID]=[Investigator1])
Name2: DLookUp([Rank_Name_Family];"tbl_Personal_Information";[tbl_Personal_Information].[PID]=[Investigator2])