Have three files - students, math scores and report cards. I want the teacher who logs on to go to report cards and do a find for their students. Then I have a button that I would like the teacher to click and it opens the math scores file with the same students already found - how do I write this? I think this is scripting 101, but I haven't passed that yet - THANKS.

Hi,

Assuming your Report Card is a file where each student is affiliated to a teacher, by the TeacherID, the quicker would be to involve relationships rather than a find process.

1. Create a global field, gTeacherID

2. Define a selfRelationship "Self#gTeacherID#TeacherID" (gTeacherID matching TeacherID).

3. Define a Value List "RelatedStudents" using this relationship

4. Create a global text field gStudentIDsHolder

5. Create a relationship to the Math Scores file "Math#gStudentIDsHolder#StudentID"

A 2 lines script :

SetField[gStudentIDsHolder, ValueListItems(Status(CurrentFileName),"RelatedStudents")]

GoToRelated Records ["Math#gStudentIDsHolder#StudentID"- show only]

and maybe an external script which would locate the targeted Layout.

HTH