Creating a team from an employee table

To achieve a "join" between two tables you need 3 Tables: 
Employees
Teams
Team Members

You need 2 Relationships: 
Employees < Team Members (Related Employee)
Teams < Team Members (Related Team)

Your Employee record will then display all Teams that the Employee is associated with; and your Teams table records will show all Employees in each Team.

Your Team Schedule will probably be associated to your Teams table; and you can embed a report link to show all the Team Members who work as part of that Team in your Team Schedule records.

Thank you for replying. Am I correct in assuming that my Team Schedule (my Join Table) is simply a data pass through and needs no fields assigned? In my Employee table I simply created a list of employees and then in my Teams table I just created Team 1, Team 2, etc. Am I on the right track or am i missing something in between?

Correct. Some join tables have no fields other than than report link fields and lookups.

If you were building a join table for say order lines, typically the fields would include quantity and unit price and extended price.

Just confirming....  An employee can belong to more than one team?  If not you would not want that logic.  But if yes, exactly as described.

Just not sure if a team refers to a department or a project team or something like that.