Results 1 to 3 of 3
  1. #1
    BarbT is offline Novice
    Windows 7 Access 2007
    Join Date
    Oct 2010
    Posts
    15

    Relationships again

    I posted about a week ago and you were all very helpful. I have spent ages looking at the sites & tutorials suggested here and I have now designed my tables based on all the advice given. I just wondered if someone could kindly run an eye over them to see if I have done it all correctly? I have to get this db ready to use asap and so any help again would be very much appreciated. I have to say that setting relationships has seemed terribly difficult but, I am hoping that I have got most of it right! If I need to upload more for you to see, please advise.



    Thanks again in advance.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    For what it is worth, it looks to me like you have the ForeignKey of the tables set up correctly. I would suggest that embedding spaces in names like "Student ID" can be problematic down the road. I use CamelFontNames myself such as "StudentID".

  3. #3
    BarbT is offline Novice
    Windows 7 Access 2007
    Join Date
    Oct 2010
    Posts
    15

    Spaces

    Thank you again - I will alter this before it causes any problems!

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

Similar Threads

  1. One to many relationships
    By CoachBarker in forum Database Design
    Replies: 1
    Last Post: 09-13-2010, 09:01 PM
  2. Too Many Relationships
    By MikeT in forum Database Design
    Replies: 4
    Last Post: 08-25-2010, 07:23 PM
  3. Reports relationships
    By nashr1928 in forum Reports
    Replies: 1
    Last Post: 07-14-2010, 08:01 PM
  4. Relationships?
    By rosh41 in forum Database Design
    Replies: 2
    Last Post: 06-23-2010, 01:26 PM
  5. Table Relationships?
    By Meld51 in forum Access
    Replies: 3
    Last Post: 03-01-2010, 08:34 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