I have two lists (not forms libraries). List 1 contains information about people (Full Name, Employee ID, and Phone Number) and can only be accessed when logged in. List 2 contains information about training requests (Training Requested, Requested Session Date, Employee ID, and Phone Number) and is accessed anonymously.
I would like a user to go to List 2 and create a new item. They would enter in the Training they would like to take, enter the date they want to take it, and enter their Employee ID. When they submit the form, I want the form to grab the Employee ID they entered, look for it in List 1, and if it is found, grab the user's phone number from List 1, and enter it in the Phone Number field on the form. So it is like an Excel vlookup from an anonymous list to a secure list.
Is there a way to do this using Secure Store?
Thanks!