Results 1 to 4 of 4
  1. #1
    digitaldb is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    16

    duplicate tables in relationship view

    Hello everyone. I am new to this forum and to Access having just finished my first book on it. I have created my own practice database based on my own work location, with several tables including employee, department, and computers. One of the relationships is a one-to-many relationship between the employee.deptID field and deptartment.ID(pri-key). In the relationship view, I now show two relationships for this one. One, the original, and a second one between employee.deptID and department_1.ID which is a duplicate of department. It doesn't seem to hurt anything but I was curious why there are now two of the same relationship ? And what made the duplicate department_1 table show up ?
    I don't remember the duplicate table being there when I created the relationship.

  2. #2
    digitaldb is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    16
    Here is a snapshot of the relationships I'm referring to:

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You can safely "hide" the 2nd Department table without affecting anything.

  4. #4
    digitaldb is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    16
    Thanks RuralGuy, I kind of thought it must have been normal Access behavior since I think I've see something similar in the past and it's never affected anything.

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

Similar Threads

  1. relationship between the tables
    By mer in forum Queries
    Replies: 1
    Last Post: 07-05-2011, 05:52 AM
  2. Replies: 3
    Last Post: 09-15-2010, 12:35 PM
  3. Relationship - Three Tables - No Duplicates
    By Huddle in forum Database Design
    Replies: 15
    Last Post: 07-27-2010, 07:45 AM
  4. Replies: 9
    Last Post: 03-24-2009, 09:19 PM
  5. Replies: 1
    Last Post: 10-28-2008, 08:38 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