>>>I have a parent table which has applicant name, and social security number. I also have two child tables, one has universities attended, date of attending, and degree; the other one has honor, and date of honor. I need to create a report which the following format.
>>>
>>>Applicant name: XXX SS No.: xxx-xx-xxxx
>>>----------------------------------------------
>>>EDUCATION
>>>1986-1990 U. of Nowhere BSc.
>>>1990-1992 U. of Nowhere MPhil.
>>>
>>>HONOR
>>>1990 Outstanding Student
>>>1991 Dean's List
>>>1992 Outstanding Student
>>>
>>>Therefore, I need to print out all the records on education table first, and then all the records on honor table. From the reprot designer, it seems to me that I cannot accomplish the above task. Can anyone help? Thanks.
>>>
>>>Chu
>>
>>Firstly, you 'concatenate' two table into one cursor:
>>Select 1 as listorder,field1,field2,field3,space(10) as field4,space(10) as field5 From table1 Into cursor tmpReport ;
>>Union Select 2 as listorder "" as field1,"" as field2,"" as field3, field1 as field4, field2 as field5 From table2
>> Now, you create report form grouped by listorder. All report fields should 'Print When' feature to distinct between listorder values.
>
>I am a bit confused. Should I create erport form grouped by social security number instead of listorder? I am a beginner on the report. Thanks.
>
>Chu
It was idea how to handle one parent record. For all parent record you have to:
1. Add 'ssno' field into Select..Union command
2. Join parent record to tmpReport to final cursor.
3. Group report form by ssno,listorder.
Edward Pikman
Independent Consultant