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 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,

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....