report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't think any more at the moment, can any one tell me how i can generate
the following report please

I have a table with StudentID, StudentName, StudentSurname,.......
I have another table ParentID, ParentName, ParentSurname,.......
I have another link table ParentStudentID, StudentID, ParentID

the third table links the parents to students

I want to generate a report to show the student with his relevant parents in
one row, like following
StudentID, StudentName, StudentSurname,FirstParentName, SecondParentName
all in one row.

any help is appreciated.
 
hi,

K. Shoghi said:
I have a table with StudentID, StudentName, StudentSurname,.......
I have another table ParentID, ParentName, ParentSurname,.......
I have another link table ParentStudentID, StudentID, ParentID
I want to generate a report to show the student with his relevant parents in
one row, like following
StudentID, StudentName, StudentSurname,FirstParentName, SecondParentName
all in one row.
Click to expand...
First create a query using your three tables to gather the information.
Then create a pivot table based on this query. Use the StudentID as row
and the ParentID as column.

Don't ignore the possibilty of more then two parents, e.g. in a case of
adoption. These cases have to be reflected in your link table.


mfG
--> stefan <--
 
Back
Top