Results 1 to 3 of 3
  1. #1
    babymonster is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2013

    I need some advise on ACCESS Relationships. Please come in and take a look

    Hi, I need some help on Microsoft Access.


    In a table I have student name, 3 course, 7 subject.
    Course 1 consist of 1,2,3,4 subject
    Course 2 consist of 3,4,5,6 subject
    Course 3 consist of 4,5,6,7 subject

    During the form input, the student can either enter the course or subject.
    If he choose 3-7 subject, during the report, it will show he complete Course 2,3 and all the subject taken.

    If he choose course 2 & 3, during the report, it will show he complete Course 2,3 and all the subject taken.

    Both will remove those duplicate subject.

    So how do I do it? relationship? query?

    Btw I use Multiple Values Lookup in both Course and Subject. Is more convenience for me. But is there any issue or conflict for other functions?

    Thanks in advance. I hope someone can give me some tips on doing this.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    I refuse to use multi-value fields because of issues they cause. You should thoroughly research before deciding on using. Start with

    Sorry don't understand the data well enough to offer suggestions on your issue.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    If you want readers to comment on your relationships, you should give us - in plain English - a few lines of exactly WHAT it is you are trying to do.

    3 or 4 lines should be sufficient.

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

Similar Threads

  1. Replies: 2
    Last Post: 12-19-2012, 03:05 PM
  2. Need Advise and Help
    By sabrish72 in forum Reports
    Replies: 3
    Last Post: 06-02-2011, 06:01 AM
  3. Newbie Need Guide and advise on Query
    By sabrish72 in forum Access
    Replies: 3
    Last Post: 05-24-2011, 08:44 PM
  4. Can anyone advise?
    By doceo in forum Access
    Replies: 0
    Last Post: 10-18-2009, 02:44 PM
  5. Some advise for a complete novice...!
    By 450nick in forum Access
    Replies: 1
    Last Post: 09-11-2009, 02:23 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