>>I need to put together a report that will print from a course table and an evaluation table. The common field for both would be a student number. The format of the report needs to show the student name (grouped on this), then line items of course info and then line items of evaluation info. Below is an example:
>>
>>Colin Magee
>> Course1 01/01/1998 ........
>> Course2 04/01/1998 ........
>>
>> EvaluationA 04/15/1998 .......
>> EvaluationB 05/01/1998 ........
>>
>>Any help on how to do this would be greatly appreciated. TIA
>
>Sounds like you need to set a relation between your Course Table and Evaulation Table based on Student Number and with Courses as parent table. Then you can create a report using fields from both tables. That would be a simple approach, if your report requires multiple groups and complex index keys, you might want to consider SQL Select'ing your data into a temp cursor or view to drive the report instead of relating the source tables with SET RELATION. HTH
Actually, and this is my fault for not making this clear before, there is no relationship between Course and Evaluation. The relationships are a one-to-many between Students and Course and a one-to-many between Students and Evaluation. The evaluations are general knowledge type evaluations and are not based on any one specific course. Your SQL suggestion gave me the idea of doing 2 SQL's UNIONed together into one cursor. Is this what you were thinking or is there maybe a better way? Thanx
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.