Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Location
    Longview, TX
    Posts
    8

    Table Relationships

    I took a class in Microsoft Access about 10 years ago, and now I find myself actually looking at an Access database.

    The database has about 35 tables of text in it and comes in at 2,872 KB.

    Wow!

    I'm trying to get a handle on how this table fits together. It seems like there was a way to look at the relationships of all the tables at one time with lines connecting an index (foreign key) in one table to a (primary) key in another, but I don't know how to get there again.

    Further, I'm using Microsoft Access 2007, so the menus don't look the same either.

    How can I get a "road map" of this database?

    Regards,
    Joe

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    On the ribbon Datadate Tools>Relationships will show you any relationships that have been set up.

  3. #3
    Join Date
    Jun 2009
    Location
    Longview, TX
    Posts
    8
    Great! Thank you.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad I could help.

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

Similar Threads

  1. Help on Tables/relationships?
    By mistaken_myst in forum Database Design
    Replies: 3
    Last Post: 04-01-2009, 05:16 PM
  2. Access - car rental relationships
    By ipwn in forum Access
    Replies: 0
    Last Post: 03-09-2009, 07:18 AM
  3. Relationships btw tables
    By metaDM in forum Queries
    Replies: 0
    Last Post: 03-05-2009, 12:15 PM
  4. auto populate and table relationships
    By jmarti57 in forum Access
    Replies: 0
    Last Post: 11-09-2008, 09:50 PM
  5. I need help on relationships for tables.
    By justin.w in forum Access
    Replies: 0
    Last Post: 10-16-2006, 10:57 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