Results 1 to 3 of 3
  1. #1
    jalal is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Posts
    17

    Unhappy updating category/subjects

    Hi
    I am new to Access
    I am trying to make a database for the school. I have created 3 tables
    Student table with 3 fields as – (a) [ID] as primary Key (b) First Name (c) Level
    SubjectCatagory Table with 2 fields as (a) [ID] as primary Key (b) CategoryName
    Subjects Table with 2 fields as (a) [ID] as primary Key (b) as Subject Name
    There are 4 subject categories (a) Science (b) Arts (c) Commerce and (d) Humanities
    There are 9 subjects in each Subject Category and the student has to select 5 subjects from the concerned category


    e.g. Student A is a Science Category student, he will chose 5 subjects from science category.
    Likewsie Student B is a commerce student he will chose 5 subjects from commerce category. And So on
    The problem is that when the student seeks admission in the school computer should allot the concerned subjects to him if he selects any subject category.
    How can I solve it.
    Please help me
    Thanks
    Jalal

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Subjects table needs a field for the SubjectCategory ID as a foreign key.

    Also need a junction table for records that associate student with subjects.

    StudentSubjects
    StudentID (foreign key)
    SubjectID (foreign key)

    Then bind form to junction table and on form have a combobox for selection of Category, another combobox for selection of Subject (bind this combobox to SubjectID field of junction table). The subjects available for selection should be dependent on the Category selected. This is cascading (dependent) comboboxes. Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in Access Forms: Control Basics section.

    Also need combobox to select student (bind to StudentID field of junction table). Or put this form as subform on another form that is bound to Students table.
    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
    jhcarrell's Avatar
    jhcarrell is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    Alabama
    Posts
    10
    Also see ... Cascading List Boxes tutorial.

    Hope that helps.

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

Similar Threads

  1. Replies: 10
    Last Post: 12-24-2011, 03:37 PM
  2. Existing template- add extra category/sorting
    By davidelsbury in forum Database Design
    Replies: 1
    Last Post: 12-18-2011, 03:30 AM
  3. Category redesign
    By squirrly in forum Database Design
    Replies: 16
    Last Post: 12-13-2011, 06:32 PM
  4. Replies: 1
    Last Post: 10-06-2009, 02:00 AM
  5. Replies: 0
    Last Post: 08-19-2008, 11:12 AM

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