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