You can make a report (letter) based on the Course requests table.
In the body you can put the Course Name from the Courses table, and any other info you would like to add. Make the body only as big as it needs to be, for instance, if your courses are just one line, make it about 18 - 22 pixels high.
In the header or the footer you could show fields from the Students table. You could make this header as big as you want.
If you make that report a list view, you'll see all the courses
There is no need to use calculations, because these fields are related. A Coursed record is available for the students table because of the relationship.
- You can use merge fields if you want to put either courses information or student information inside a piece of text.
- You need to perform a find for a certain student ID to see only this students information.
- You can craete a script. That sets the studentId as a variable, goes to the report layout, performs a find to fint that student, and prints the report.
If you neeed any help or examples, let us know.
P.S. I think this file might be an example of this, but I don't have windows open right now, you might want to have a look.
The name would suggest it might be helpfull :)