Is it correct that you only have one table now? The table with the students info.
Will you only do one inspection? Or will there be multiple inspections over a period of time?
And do you want to keep a record of these inspections?
Because then you could create a second table "Inspections" and create a field in it called "StudentIdFk" (Fk stands for Foreign key)
Then you could create a relationship between Students::StudentId and Inspections::StudentIdFk
Then your inspections layout can be based on your inspections table and your dropdown is on the StudentIdFk field.
If this is not the case and you want to work with only one table you could create a global field that acts as a dropdown to select a student. And you set a "OnObjectModify" script trigger to "go to related record" of this student.
One table yes.
One inspection only.
I just need to do the lookup and land on the right record in this single layout.
So can you give me example code on how this works with the dropdown list?
Or is this as simple on creating a global field (which I currently don't know how to do) and use a value list based on students first and last name?
How do I attach the script trigger to the value list???
Depending on whether you use a drop down list or pop up menu, you may want to use OnObjectSave instead of OnObjectModify. (OnObjectModify will be tripped each time you press a key, so it's not the best choice if the user can also enter the name as well as select it from the value list--as is usually possible with a drop down list.
Instead of Go To Related Records, a script performed by that trigger can also perform a find to locate the student or students with that name.
The basic idea is for the staff to pick a name from the drop down and then that record would be displayed. That dropdown is on the same layout. So can we be more specific based on this
Define a field with global storage. Let's say your table is named "student Info" and your field is named gFindStudent. Use field options to give gFindStudent global storage or this script will not work.
Enter Find Mode 
Set field [Student Info::StudentName ; Student Info::gFindStudent ]
Set Error Capture [on]
Perform Find 
If you plan to use a drop down list with auto complete enabled, use the OnObjectSave trigger to perform the above script.
The above script is the "bare bones" solution. It can be enhanced to display a message if no student record was found or if multiple records for the selected student name was found.
Hey Michael, I made you a little, very basic example.
It also shows a method I always use and that's the ability to open a list view to be able to select a record.
But the dropdown is also thre; Just like PhilModJunk explained it.
My Go to related record didn't work. So I used a find instead.
Like PhilModJunk said, you can take this a lot further.
Just experiment a little.
Nothing wrong with Go To Related Records, BTW, it just requires a relationship you don't have at this time in your database. A self join relationship based on that global field matching to the student name would make it work, but the scripted find can match on partial names so it's a bit more flexible for what you want here.
Thank you PhilModJunk and DaSaint.
I just got back from lunch and will look at DaSaint's example and PhilModJunks info, right now!
Let you know shortly!
Just a quick question.
DaSaints example uses Name (being the entire name).
I have first name and last name fields.
Can the example still work?
You might want to define a calculation field named something like cFullName and defined as:
last name & ", " & first name
There are a number of ways to set up that calculation. This is just a very simple option. Other calcs have been devised that handle middle names, initials and also cases where a person only has a single name.
OK I'll give that a try.
Ok I have a problem.
When I click the drop down, the list of last names shows and when I select the last name the display doesn't change to reflect the choice I made.
The area I think is causing the issue is in the script. (BTW on the dropdown field I do have the trigger to onmodify, to set off the script).
I used the script from DaSaints example.
The thing I noticed is that in the Enter Find Mode  and Perform Find Mode  part of the script where you would specify the find request, DaSaints example shows a find request and mine is empty. if I enter a value like 2, then the Find Mode shows Find Mode [Restore]
What criteria do I need here?
Never mind guys, I was missing the calculated area in set field.
Thanks again for all your wonderful help!