multiple persons selection

[greeknl via AccessMonster.com]

I have downloaded the "Issues Database" from MS. I have made changes to it to
suit my needs.
Anyway, I get stuck on one thing though. In the databse you can assign a
person who opened the issue and assign one how will address the issue.
Actually in some cases I want to have more then one person addressing the
issue. I have a table with all the persons in my department.
How can I do this the right way, also I want to be able to send an email to
the persons adressing the issue in one go.
I thought about using a multiselect box but then how do I send email to all
of them.
Also I would very much like to be able to just select the persons and display
only their names and in a particular order (rank within the company
(selectbox would be alphabetical))
And sending them an email is not the only thing I want for the team, so
somehow they should be connected all to the particular issue

Thank you

 

[Steve]

You need the tables:

TblIssue
IssueID
IssueDescription
PersonwhoOpenedIssueID

TblPersonsAddressingIssue
PersonsAddressingIssueID
IssueID
PersonWhoWillAddressIssueID

Make a form/subform from these two tables and you will be able to enter
multiple persons addressing an issue.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)