Re: Allocate multiple entries under same ID (team)
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.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.