Allocate multiple entries under same ID (team) (1 Viewer)

eugenelim0410

New member
Local time
Today, 14:03
Joined
Aug 13, 2018
Messages
7
I want to allocate multiple employees into a team. How can I do that? I got employee table consist of: ID, Full Name, Address. Team table's main function is to allocate the employees under the same team ID. Is that possible?
 

jdraw

Super Moderator
Staff member
Local time
Today, 17:03
Joined
Jan 23, 2006
Messages
15,364
Team----IsComposedOf---->EmployeeID

A Team has 1 or more (many) Employee.

So you have a 1:M relationships between Team and Employee
Here's a link to related info.
 

eugenelim0410

New member
Local time
Today, 14:03
Joined
Aug 13, 2018
Messages
7
But I not sure how to add the multiple employees into a same team in a form. As when I use a button to save the updates, it shows that duplication of team ID while I was actually expecting multiple employee ID(s) to be added into the team ID
 

jdraw

Super Moderator
Staff member
Local time
Today, 17:03
Joined
Jan 23, 2006
Messages
15,364
You could have a combo with Team Names and a second combo with AvailableEmployees, and a Button.
Select a Team, then select an Employee for that Team.
Then, click the button to invoke code to add a record to table TeamMember using the TeamId and the EmployeeID.

This requires some vba for the button click event.
Also, once you assign an Employee, you would remove that Employee from AvailableEmployees.

Just some thoughts for consideration.
 

Users who are viewing this thread

Top Bottom