Results 1 to 3 of 3
  1. #1
    Merkava is offline Novice
    Windows XP Access 2002
    Join Date
    Nov 2009
    Posts
    20

    DB Design

    Hello All,



    I am designing a DB to use at work. I have two tables:

    Table #1- Table #2

    tblEmployee tblTeam
    fld EmpID fldTeamID
    fldEmpFName fldTeamLeaderID
    fldEmpLName fldTeamDesc
    fldTeamID

    The bold and underlined fields are the primary keys
    The problem I am having, if it is a problem, is that the agent is connected to the team via tblEmployee.fldTeamID and tblTeam.fldTeamID, now the team leader would be connected via tblEmployee.fld EmpID and tblTeam.fldTeamLeaderID

    Is it reasonable that tables are connected to each other twice?

    Cheers,
    Aaron

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    no

    Team Leader is not connected as a relationship. It is simply the leader's Employee ID entered as a value in the fldTeamLeaderID in the Team table...that's all. don't overthink it....

  3. #3
    Merkava is offline Novice
    Windows XP Access 2002
    Join Date
    Nov 2009
    Posts
    20
    Thank you

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

Similar Threads

  1. Attendance design
    By 8rxtx8 in forum Database Design
    Replies: 0
    Last Post: 07-19-2009, 04:42 AM
  2. Database Design
    By mzrihe1x in forum Database Design
    Replies: 1
    Last Post: 06-17-2009, 09:09 PM
  3. design problem
    By marianne in forum Database Design
    Replies: 7
    Last Post: 05-26-2009, 07:25 PM
  4. Design Question
    By bdriscoll in forum Database Design
    Replies: 3
    Last Post: 05-03-2009, 08:57 AM
  5. Design help
    By marix in forum Database Design
    Replies: 1
    Last Post: 04-18-2007, 07:54 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