I have a small requirement where in i need to populate Managers Name and Leads Name (People Picker Field) based on value entered in another People Picker Field which is Employee Name in Vacation List.
The Employee name are mapped to Managers name and leads name in another list which is Master List.
Requirement: As the user opens the new form and puts his name in Employee Name field, the manager name and leads name people picker field should auto populate from Master List.