Choose student from list and display?
I have two layouts. One is for student info entry and one for student room inspection.
The student entry is up and working and filled with student info.
On the student inspection layout (it uses the same student table as the student info), I have student name and room number on the first tab and other tabs with various rooms in the students apartment (bathroom, kitchen , etc)
I would like drop down list on the first tab area to find a student and have their record pulled up.
What's the best way to go about this?