>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
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos