Populating lookup fields with dynamic values based on another lookup
I have a form that students currently fill in to choose their course choices for next year (very basic form).
Once this data is entered I want enrollment counselors to start a new form which has a lot of information, but I want to pre-fill the course choices lookup fields section if data has been entered by a particular student (enrollment counselors will initially select the student that they are enrolling in a lookup field and this is when I want the pre-fill / dynamic values updated to occur) . These lookup forms also need to be able to lookup the course selections (data in another form) if the student has not pre-filled the data or changes need to be made to the enrollment (Yes its starting to get complicated now).
Long and short of it.....
Student Logs in > Enters Courses into Form A> Submits
Enrollment counselor > Logs in > selects student in Form B> has access to all data that student has previously submitted in Form A in lookup fields which also is looking up available courses.
I've attached some pictures for some visual aid.
Any help appreciated 🙂