Results 1 to 6 of 6
  1. #1
    ladieballer2004 is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2009
    Posts
    3

    PLEASE HELP one to many relationship and a Report

    I'm pretty new to Access so bear with me. I have two tables ApplicantInfo and Involvement. ApplicantInfo holds the typical columns (FirstName, LastName, Phone..etc) The Involvement table can hold up to three rows of information from the same applicant (Acitvity, Position, Start Date, End Date) When I try to create a report that shows the majority of the data from ApplicantInfo along with the three records from the Involvement table, I'm given 3 reports for the same user, included is one different involvement record for each form. How do i resolve this?

    Thankyou in advanced

  2. #2
    genesis is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    39
    what are the exact fields in your ApplicationInfo and Involvement Tables?

  3. #3
    ladieballer2004 is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2009
    Posts
    3
    ApplicantINfo Table:
    FirstName, LastName, Class, Residence, CumGpa, ULVGpa, Hobbies, College, HighSchool, ShortAnswer1, ShartAnswer2

    INvolvement Table:
    Activity, Position, StartDate, EndDate
    ----------------------------------------------
    The Primary key for ApplicantINfo is ULVID and it is a Foreign Key for the Involvement table. There is a one-many relationship on the Involvement side. The involvement records should all show on one report for each applicant.
    -----Basically this is an application that was once paper form and now we are having the applicants apply online. However we still need to print a paper version for application review.

  4. #4
    genesis is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    39
    basically you would want to have a common ID for your both tables here so that you can have a proper relationship between those two tables.

    ApplicantINfo Table:
    ApplicantID1, FirstName, LastName, Class, Residence, CumGpa, ULVGpa, Hobbies, College, HighSchool, ShortAnswer1, ShartAnswer2

    INvolvement Table:
    ApplicantID2, Activity, Position, StartDate, EndDate

  5. #5
    ladieballer2004 is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2009
    Posts
    3
    Maybe I'm not explaining myself thoughly:

    I am trying to build a report from two tables. ApplicantInfo and Involvement. There is a one to many relationship between the two tables. ApplicantINfo being the parent table. How do I explain to the database that i want many records from the Involvement table to be shown on one report combined with the data from the ApplicantINfo table? I need steps please. I've never really used access before. But i do have the one to many relationship defined already.

  6. #6
    genesis is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    39
    when you set up your PK in your ApplicationInfo to No Duplicates and you also set your FK in your Involvement Table to Yes allow duplicates, then automatically when you join those keys, a ONE-to-Many Relationship will be created.

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

Similar Threads

  1. Many-to-Many Relationship
    By Carolyn1 in forum Database Design
    Replies: 0
    Last Post: 09-25-2006, 02:04 PM
  2. Many to Many relationship
    By Marlie in forum Database Design
    Replies: 6
    Last Post: 08-18-2006, 01:49 PM
  3. one to many relationship
    By pe_z in forum Database Design
    Replies: 2
    Last Post: 02-17-2006, 10:44 PM
  4. Replies: 1
    Last Post: 12-29-2005, 01:15 PM
  5. MAY TO MANY RELATIONSHIP
    By fadone in forum Database Design
    Replies: 2
    Last Post: 12-20-2005, 09:03 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