I have 4 tables set up with one table as the main table and the other 3 in one-to-one relationship to the main table.
The main table contains student info (name, ID, etc.) and each of the other 3 tables contains info about a specific year of their program...tblOne = courses in year 1, tblTwo = courses in year 2, tblThree = courses in year 3.
I want to run a query to print a report of the student's progress. The problem is, if the student is in year 1, no record exists for them in either tblTwo or tblThree, and the query cannot return anything on that student. There are no problems with a student in year 3, since a record exists in each of tblOne, tblTwo, and tblThree under that student's ID number.
Is there some way I can get the query to return all students, regardless of what year they are in?
Many thanks for your help and advice!
The main table contains student info (name, ID, etc.) and each of the other 3 tables contains info about a specific year of their program...tblOne = courses in year 1, tblTwo = courses in year 2, tblThree = courses in year 3.
I want to run a query to print a report of the student's progress. The problem is, if the student is in year 1, no record exists for them in either tblTwo or tblThree, and the query cannot return anything on that student. There are no problems with a student in year 3, since a record exists in each of tblOne, tblTwo, and tblThree under that student's ID number.
Is there some way I can get the query to return all students, regardless of what year they are in?
Many thanks for your help and advice!