Hello, we are in the process of scanning in some student documents for our school district and wanted to setup dynamic fields to use the student ID to find the first and last name from our database.

The problem is, our student list is nearly 70,000 and when trying to type in a student ID, the list just breaks while trying to load and sort. I was hoping we could setup a stored procedure to use the student ID and locate the first and last name without that initial display of all students as a dropdown. Any suggestions?