General information
Category:
Reports & Report designer
Title:
Re: Report on two child tables
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only