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?

[Suvrutt_Gurjar]

HI @WhiteCrow_MD, I request you to take a look at the other post that you had posted.

[Alex_Meraru]

If you want a pin assigned to a name then the name should be unique so make the name the key and then it will store the name