How do I write a script that uses a teacher ID, which is their last name plus the last four digits of their social sec. # to find only the students that are assigned to them. Have a student database with field called currentTeacher; a teacher database with all the teacher IDs; a report card database that has the currentTeacher field. I want to write a script that when the teacher enters their teacher ID it goes directly to the report card layout with their students. Example nardini3456 would go to the report card layout for students belonging to Mrs. Nardini. I'm new to FileMaker and would appreciate any help. thank you. (FM 6 and 5.0)

Add a Report Card portal to the Teacher database layout. Add a button to the portal row and attach a script to Go to Related Record (specifying the layout you want in the Report Card file).