Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-16-2018, 06:41 AM   #1
eugenelim0410
Newly Registered User
 
Join Date: Aug 2018
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
eugenelim0410 is on a distinguished road
Allocate multiple entries under same ID (team)

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?

eugenelim0410 is offline   Reply With Quote
Old 08-16-2018, 06:52 AM   #2
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 11,535
Thanks: 54
Thanked 1,871 Times in 1,821 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
Re: Allocate multiple entries under same ID (team)

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.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
Old 08-16-2018, 06:56 AM   #3
eugenelim0410
Newly Registered User
 
Join Date: Aug 2018
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
eugenelim0410 is on a distinguished road
Re: Allocate multiple entries under same ID (team)

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

eugenelim0410 is offline   Reply With Quote
Old 08-16-2018, 07:33 AM   #4
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 11,535
Thanks: 54
Thanked 1,871 Times in 1,821 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
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.
jdraw is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple entries into single entries Neokey Queries 5 01-08-2016 05:44 AM
Multiple Entries Prayder Forms 2 11-04-2014 07:42 AM
Multiple entries moori Theory and practice of database design 9 03-05-2012 02:44 PM
Multiple Entries zmt-ohio General 1 10-05-2009 01:05 PM
Multiple Entries Randomblink Forms 0 07-23-2001 11:41 AM




All times are GMT -8. The time now is 09:19 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World