Hi! I am designing a student management system and I am facing some big problems. I have three tables: Student, Curriculum and Subject. There is a many to many relationship between Curriculum and Subject, which resulted in a table AnualSubjects. For each student I would have to know what subjects they have chosen and from what curriculum, therefore I would need a relationship between Student, Curriculum and Subject. I have designined a resulting table named SubjectsStudied with the primary keys StudentID, CurriculumID and SubjectID. After I enter the StudentID and the CurriculumID, I want it to allow me to choose from a combo box only those Subjects which exist in the Curriculum and which I have previously edited in the AnualSUbjects table. How can I solve this problem??? I really need help as soon as posible!!!
Thank you very much!