Results 1 to 3 of 3
  1. #1
    JeRz is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2014
    Posts
    33

    One to Many Relationship Question

    Hi All,



    I have a database with 2 tables. A Members table and an Issues table. In the Members table, I have the PK as PatientID. I am trying to determine the best design method to link the Members and Issues table. Is it good design to have the PatientID also in the Issues table? I have read comments while researching this that state not to save the same data in two places. What would be the best practice with this?

    Thank you!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Both tables need a similar key.
    I would think tMember would have MemID
    and tIssues would have IssueID.

    or you can call it PatientID. Either way the child table needs a MemID and allow duplicates.

    tMEmbers tbl
    MemID (autonum)
    name
    addr, etc


    tIssues table
    IssueID (autonum)
    MemID (long integer) allow duplicates
    issue descrpition
    etc..

    In relationsships, join the 2 MEMID on both.
    Then in a form you can make a parent/child form to see all issues for 1 member.

  3. #3
    JeRz is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2014
    Posts
    33
    Quote Originally Posted by ranman256 View Post
    Both tables need a similar key.
    I would think tMember would have MemID
    and tIssues would have IssueID.

    or you can call it PatientID. Either way the child table needs a MemID and allow duplicates.

    tMEmbers tbl
    MemID (autonum)
    name
    addr, etc


    tIssues table
    IssueID (autonum)
    MemID (long integer) allow duplicates
    issue descrpition
    etc..

    In relationsships, join the 2 MEMID on both.
    Then in a form you can make a parent/child form to see all issues for 1 member.
    Thanks for your help!

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

Similar Threads

  1. Many to Many Relationship Question
    By Stewww in forum Database Design
    Replies: 6
    Last Post: 09-14-2016, 12:23 PM
  2. Relationship question
    By mjwakema in forum Database Design
    Replies: 4
    Last Post: 10-28-2015, 05:13 PM
  3. One to One Relationship question
    By ittechguy in forum Database Design
    Replies: 2
    Last Post: 09-09-2015, 07:50 AM
  4. Relationship question
    By txlibertygirl in forum Access
    Replies: 2
    Last Post: 10-13-2011, 08:59 PM
  5. Relationship Question on one-many
    By daveofgv in forum Database Design
    Replies: 2
    Last Post: 05-08-2011, 10:39 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