Allocate multiple entries under same ID (team)

[eugenelim0410]

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]

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]

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]

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.