UI suggestions for associating existing records (rather than adding new ones via a portal)
I have a 'class' table, a 'student' table and a 'classstudentmap' table (in MySQL, frontended by a FileMaker 9 server holding the FileMaker database, connected to by FileMaker 11) relating them to each other.
Theres a view of the classes with a portal displaying the students from each class.
I'm after suggestions as to how to allow users to add existing students to a class (ie something like displaying a list of (currently unrelated to the class) students from which one can be selected by the user), ie not by entering the student info in the last row of the portal. Bonus points if there's a nice way to present the option of adding new or existing students (rather than have a separate button for each...)