Hi, I was making a database for an educational institute, which has classes for each level of education.
There are 3 tables engaged together: Schools working with this institute, Classes holding in the schools, and the Students participating in classes.
the schools and classes are unique, and each new class gets a new id, but the students may appear in some classes.
all the classes' subjects are the same, but their level are difference, and each student start with a Level A class,and then goes to Level B class and so on.
after making relationships, in school table left side of its id field, there's a plus sign which expands the related classes table, and in the expanded table also, there's a plus sign next to class id which will expand the related students table.
the problem is that one student from the student's table cannot appear in more than one class because of relationship and manner of ids.
so is there any method to solve this problem in its way ? or it should be changed to another way ?
I did attach an example access file by the way.
Thanks A lot !
There are 3 tables engaged together: Schools working with this institute, Classes holding in the schools, and the Students participating in classes.
the schools and classes are unique, and each new class gets a new id, but the students may appear in some classes.
all the classes' subjects are the same, but their level are difference, and each student start with a Level A class,and then goes to Level B class and so on.
after making relationships, in school table left side of its id field, there's a plus sign which expands the related classes table, and in the expanded table also, there's a plus sign next to class id which will expand the related students table.
the problem is that one student from the student's table cannot appear in more than one class because of relationship and manner of ids.
so is there any method to solve this problem in its way ? or it should be changed to another way ?
I did attach an example access file by the way.
Thanks A lot !