Results 1 to 4 of 4
  1. #1
    barrensb is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    May 2019
    Posts
    2

    Trouble with table relationships

    HELP!! I am attempting to create relationships between my tables and am struggling mightily .






    There will be many students (student demographic tbl), some of which will have completed many programs (program tbl), all will have completed many assessments (assessment tbl), some students which will have many clinicals (clinical tbl), all students will have only one admission (admission tbl), and the tblP_Reports is a stand alone and needs no relationship.



    Thank you so much for your time!

    Click image for larger version. 

Name:	Bonesdb.jpg 
Views:	17 
Size:	129.3 KB 
ID:	38521

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    cross posted
    https://www.utteraccess.com/forum/in...ic=2053934&hl=
    https://access-programmers.co.uk/for...d.php?t=305257

    When you cross post -- post same or similar post on multiple forums, you should identify that you have done so, and provide links to same.

    Here is why.

    You do have responses at the 2 sites noted.

    I recommend that you research Normalization.
    Also, the Database Planning and Design link in my signature has many articles in different formats that you may find helpful.
    Especially - the tutorials from RogersAccessLibrary; the Database Principles (the attached pdf file).
    Good luck with your project.

  3. #3
    barrensb is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    May 2019
    Posts
    2
    Gotcha. This makes sense. Thank you for the information on cross-posting as well as the resources for my project!

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

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

Similar Threads

  1. Having trouble creating relationships.
    By qwerty in forum Access
    Replies: 19
    Last Post: 10-29-2018, 12:49 PM
  2. Replies: 9
    Last Post: 11-22-2017, 09:13 AM
  3. Replies: 3
    Last Post: 10-10-2017, 08:09 AM
  4. Replies: 6
    Last Post: 11-08-2013, 03:48 PM
  5. Replies: 1
    Last Post: 07-27-2010, 08:02 AM

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