I have a staff details form (HR_Form) that one person has to enter Employee Name, Start Date, etc.

The next person has to fill out an IT requirements form.

I want the Employee_Name field in IT_Form to be pre-populated with the value from the Employee_Name field in the HR_Form.

What is the best way to do this?

Ideally, the person filling out the IT_Form clicks a link in an email, and is prompted to fill out the form, and the form knows what to prepopulate.

But my first goal is to just select the Employee Name from a drop down list in the IT Form. This would then populate Start Date field and a few others.

I've tried a lookup field, but it doesn't fill anything out, just lets me select from drop down values.

I'd like to not see a drop down for any field other than Employee_Name. Once Employee_Name is selected, populate IT_Form.Start_Date with HR_Form.Start_Date.

Thanks in advance.