Creating a team from an employee table
I have an employee table and I have a teams table. My goals is to be able to create a group of teams from the employee table. It is my understanding that if I create a join table and create a relation...
Forum Discussion
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.
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.