Yes you can. check out "editing record access privileges" and look at using account names to limit access in the help index. You seem to be looking to do the same thing, but instead of tagging each record with Get(AccountName) you would be looking to have a third party assign an accountname who would handle the record.
1. create a value list of Mentors and attach it to a new "Mentor" field on each record in the "Student" table.
2. limit the access privileges of the mentors to only view student records when:
Student::Mentor = Get(AccountName)
Does this sound like what you're after?
Yes. Thank you!! I'll let you know how it goes.
That was so easy. Thank you!!
Is it possible to sort all the students the mentor has accessed to when the mentor logs in? For instance, say I have a 100 student records, and a mentor is responsible for 25 of those students. When this mentor navigates to the Student Records all 25 are not the first 25 records in the list. Is it possible to make those 25 records sort to the beginning of the list when a mentor logs in?
Rather than "sort", you'll probably want to "find" instead.
In FMP10 you could trigger a script to do this. In FMP9, you'll need to activate the script manually:
Enter Find Mode 
SetField [Student::Mentor ; Get(AccountName) ]
Set ErrorCapture [on]
Perform find 
If Get (FoundCount < 1 )
## Do what should be done if no students are assigned to this Mentor ##
Sort Records ## Optional: ###
Put a button on the layout labeled "Find My Students" and have that button run the above script.
Is that what you're after?
Yes. Thank you again!!
Sorry for the delay on getting back to you... got pulled off onto another project for a few days. I just modified my current find according to your instructions and it works flawlessly. Thank you so much!!