>>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
>
>A one to many relation between course into evaluation table will solve. Also a simple relation inverse (Evaluation table into course one). Grouping on student name (Better code) and on course name (better code). In each group header the name of the item, and in the detail band the evaluation info. Hope this helps.
Thanx. Please see my reply to Roxanne.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.