horizontal to vertical

[John_Waterman_(Guest)]

I am trying to write a report where I have a possible one to many relationship. My intention is to list each of the many in separate fields on a horizontal plane. Specifically, I have a student.dbf with a stu_id field and a teacher.dbf with a teacher_id and a stu_id. Each provider for a student would be an additional entry of student and teacher id (ie. from no providers to many providers). Desired end product is a report with fields of ...stu_id...provider1...provider2...provider3...provider4 up to provider6. Any suggestions on how to go about this?__Thanks,__John

[kfleming]

Go to http://www.livewarepub.com/technote.htm and look at the article:__Printing Related Records__We have had several inquiries lately from R&R Report Writer users who wanted to print field values from multiple records in a scanned file on the same line of a report. Since these users did not always know how many records in the scanned database would match a record in the controlling database, they could not use R&R Report Writer^s /Print Options/Record-Layout "Records across" option to solve their problem. ______This should help.____Kathleen

[jwwaterman]

Kathleen,__Thanks! Gee, what service. I barely get a question posted and you have an answer.__John