Thats strange because both fields are the same they are both Ref_Number.
The set up is -
Datasheet with Ref_Number (PK) set as a hyperlink, on click = DoCmd.OpenForm "Job_Info", , , "Ref_Number = ' " & Me.Ref_Number & "'"
Job_Info is a form which contains the info from the job in a more detailed way.