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