aself

Thank you! Searching for "Picker" brought up several threads that address this problem. Thanks for the direction!

Hi everyone, I've searched and searched the forums but can't find a solution to my problem even though it's probably fairly simple. I'm trying to add students to a roster (I choose the class, then want to choose the students to add to it). I've figured out how to create a value list that populates the foreign key but it takes too long to find each student (there are about 4500 students). I'm doing it on a "Roster" layout based on that table. Anyone have a solution? I've attached a picture of the relationship diagram. Thanks so much!

How did you fix this problem? I'm having the same one.