I have a table containing 12 classes per student and 12 teachers per student.
The table contains a class-id as the key into another table to retrieve a class description and a teacher-id as a key into a 3rd table to retrieve the teacher name. The 12 class descriptions and teachers are to print on a report by student. I was told that to get Access to use the id fields as keys into the other tables to retrieve the descriptions and name I needed to set up a query.
The query contains the main table with the 12 classes/teachers and id fields joined to that are 12 class tables linked by the class-id and 12 teacher tables linked by the teacher-id. So in all there are 24 tables joined to the main table.
The query itself works fine. My problem is I use that query to create a student schedule report that lists the 12 classes the student is enrolled in and the teachers of those classes. The report is fine for the first 25 students but when I enter the 26th student into the table and try to run the report, Access hangs. I do alt-ctrl-delete and it shows Access is "not responding" and I have to kill it. If I delete the 26th student, the report runs fine.
My question is, is there some kind of limit, either query or report, that is limiting me to only 25 students? Am I doing it this all wrong to begin with? Since I have the classes and teachers stored in other tables, I was trying not to have them duplicated in the student schedule table.
Thanks,
Rod
The table contains a class-id as the key into another table to retrieve a class description and a teacher-id as a key into a 3rd table to retrieve the teacher name. The 12 class descriptions and teachers are to print on a report by student. I was told that to get Access to use the id fields as keys into the other tables to retrieve the descriptions and name I needed to set up a query.
The query contains the main table with the 12 classes/teachers and id fields joined to that are 12 class tables linked by the class-id and 12 teacher tables linked by the teacher-id. So in all there are 24 tables joined to the main table.
The query itself works fine. My problem is I use that query to create a student schedule report that lists the 12 classes the student is enrolled in and the teachers of those classes. The report is fine for the first 25 students but when I enter the 26th student into the table and try to run the report, Access hangs. I do alt-ctrl-delete and it shows Access is "not responding" and I have to kill it. If I delete the 26th student, the report runs fine.
My question is, is there some kind of limit, either query or report, that is limiting me to only 25 students? Am I doing it this all wrong to begin with? Since I have the classes and teachers stored in other tables, I was trying not to have them duplicated in the student schedule table.
Thanks,
Rod
