Report Data

M

mike

i'm reposting this question from "fields" b/c I can only see the original two
posts the other replies are not showing up...they were there and now there
gone???

trying to create a report from:
tblStudent (list of students)
tblSubject (list of subjects)
tblStudentSubject (list of which student is recommended for which class)

tblStudentSubject contains studentID and subjectID. when i run a report i
get the studentID and subjectID but i need the actual name and subject. how
to i produce this using the id fields in this table?
 
J

John W. Vinson

i'm reposting this question from "fields" b/c I can only see the original two
posts the other replies are not showing up...they were there and now there
gone???

trying to create a report from:
tblStudent (list of students)
tblSubject (list of subjects)
tblStudentSubject (list of which student is recommended for which class)

tblStudentSubject contains studentID and subjectID. when i run a report i
get the studentID and subjectID but i need the actual name and subject. how
to i produce this using the id fields in this table?
Click to expand...

There seems to be a problem with the Microsoft webpage - messages which ARE on
the newsgroups aren't visible there. This fate may await this message too... I
hope you get it!

Your Report should be based on a Query joining ALL THREE tables: tblStudent
joined by StudentID to tblStudentSubject, joined by SubjectID to tblSubject.

This gives you the subject name from tblSubject, the student bio information
from tblStudent, and any fields you have also included in tblStudentSubject.
There may not be any such, in which case the table just provides the link
between the two "data" tables.
 
Top