Results 1 to 4 of 4
  1. #1
    LauraL is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2012
    Posts
    2

    Student Management Systems - problem

    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!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,046
    Sounds like dependent comboboxes. Review http://datapigtechnologies.com/flash...combobox2.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    LauraL is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2012
    Posts
    2
    It should be like this, but I doesn't work because Subjects and Curriculum are not directly related. They are related through the table AnualSubjects, and I take my primary keys in SubjectsStudied from Subjects and Curriculum. Am I missing something?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,046
    Should SubjectsStudied have fields for StudentID and AnualSubjectsID (instead of SubjectID and CurriculumID)?

    Want to provide db for analysis? Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Operating systems
    By nashr1928 in forum Access
    Replies: 3
    Last Post: 12-05-2011, 03:24 PM
  2. student question
    By scarlettera in forum Access
    Replies: 7
    Last Post: 03-27-2011, 12:03 PM
  3. Student Information Systems
    By DrCreosote in forum Access
    Replies: 1
    Last Post: 09-29-2010, 06:33 PM
  4. systems tables
    By ldbeeman in forum Access
    Replies: 2
    Last Post: 09-18-2010, 05:42 AM
  5. MS-Access in 64 Bit operating systems
    By todd in forum Programming
    Replies: 2
    Last Post: 08-26-2010, 04:25 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums