How do I add numerous names from a contact table to another table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I designing a form that collects information on work done an a daily basis.
I would like to add the last names of personnel that worked on an assignment.
The last names are chosen from a drop down or selection dialogue from the
contacts table. This information is stored in another field.
 
With stuff like this, I usually use two list boxes; one to contain the names
of all the people, and the other to contain the names of those I've
selected. Code in the DblClick event of the first, adds the selected item to
the second.

Now, you stated that this information is stored in another field. Storing
multiple units of information in the same field is a database no-no! You
should create a new table to contain the list of people selected:
tblAssignees
AssigneeID (Primary key)
AssignmentID (Foreign key)
EmployeeID (Foreign key)

When you've finished selecting the people who worked on that assignment,
click a button to save the data.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top