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?
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?