Related records results to text field

[jaredn]

Hi all-

Great website here... I've found lots of answers to my problems so far, but it's time to post my own :-)

So, I've got a database of students and teachers for a Jazz Dept. I want to make a report of what Studios a student is in (a Studio is taught by 1 teacher, and I've made the name of the studio the teacher's last name). I have a join table assigning students to each studio, so it's easy to go to related records and I get the studios that are assigned to the student. My question is, how can i copy the name of the related teacher name, into a new text field? I have a portal that normally displays this info, but I want it horizontal instead of vertical, to save space on the report... thus the text field. See the attached screen shot.

Thanks!

[Rob 7 Collins]

do you want a horizontal listing of students by teacher in "view as table" mode??

that's not pleasant to do.

otherwise, I'd guess you want report of students by teacher:

1. Create a new layout/type "columnar report" on students,

2. with grouped data,

3. include all student fields and the teachers name field,

4. group by teacher name (use teacher's name as a category),

5. optionally select to sort by student name (or grade or ...)

and finish the layout wizard. I think that should do it.