Hi All,
This one has really stumped me:
- I have a multi-select drop down box called "People To Notify".
- It uses a table called " Employees" which has "Employee" and 'Email" columns.
- This box selects from the "Employee" column.
- It works great!
- I have another multi-select box called "Peoples Emails".
- It uses the same table called " Employees" which has "Employee" and 'Email" columns.
- This box selects from the "Email" column and is dependent on the above 'People To Notify" multi-select box.
So when I select an Employee from the "People To Notify" multi-select box corresponding email shows up in the "Peoples Emails" multi-select box and is selected.
If I select more than one Employee from the "People To Notify" multi-select box their corresponding email adds the "Peoples Emails" multi-select box, but only the last one I selected is selected.
If I select more than one Employee from the "People To Notify" multi-select box their corresponding email adds the "Peoples Emails" multi-select box, but I need all emails from first to last selected, not just the last one added.
This "Peoples Emails" field is used to feed the email "To" field to send email I need to send all that in it to be used a recipients.
Anyone know of a way to have all options appearing in the "Peoples Emails" multi-select box selected?
Scott