I have a table named Student. I have another tables named Grades. Grades holds all the classes taken with their grade, semester and other related information. They are both related with Student ID. Example: I need a script that will print the 2nd semester grades for the students selected. If the user selects a group of 10 students, then how can I have those same ten students selected have only their 2nd semester grades printed, one after the other. I am somewhat lost as to how to loop through the records selected. Hope someone has an example to see, test and modify for my case.

Instead of looping, use the Go to Related Record[] script step, with the option to match all records in current found set. This will get you all grades of the 10 found students. Then use Constrain Found Set to reduce the found set to 2nd semester grades only.

I am somewhat lost. What I wish to do is have the user perform a find from Layout A, which uses table Students. The grades are in table Grades but will print using Layout B, which is from table Grades. How can or will print each respective student's grades using Layout B. Perhaps my problem is writing script steps logically to get the desired results. More help is appreciated.

Roughly, you script would look like this:

Go to Related Record [ Grades ; Match found set ]

Enter Find Mode

Set Field [ Grades::Semester ; 2 ]

Constrain Found Set

Sort Records (by StudentID)

Print

Your print layout should have a sub-summary part (when sorted by StudentID). If you want separate printouts, define this part to start a new page before/after each occurrence.

Edited May 3, 200817 yr by Guest

Hello. Thank you. Will do. I will let you know how it works.

I am getting erratic results. For some reason the first record printed, has the correct classes printed for the semester, but the remaining records printed have the classes of the next student printed to their transcript. The last record printed has no classes printed. Will continue looking for solution.

It's hard to determine what's wrong without seeing what you have done. There are two separate parts here: one is how to find the grades you want to print, the other is how to print a report on ANY set of grade records. It seems it's the second part that you haven't implemented correctly.