How can I make the daughter table use another...

[WhiteCrow_MD]

How can I make the daughter table use another column in the parent table? I have two sheets,

1.)General Data of patients with [PIN] as key and [Name] of patients 2.)Admission of Patients with [Name] referenced from General Data, and [Diagnosis] Problem: At the backend on the second sheet, the app will store the key instead of the name of the patient. How do I force the application to check for the key of and use the [Name] for that key in the second sheet?