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!
