HELP!!! To_Email from drop-down list/repeating table

[danlin99]

I have a (2) column repeating table with the following fields using drop
down lists on both:

1) Approver_Dept - hardcoded 10 different departments
2) Approver - data connection to a SQL view (vw_empl) that contains
Empl_names, Email_Addr.

Sample data:

vw_empl (SQL view):
Last_First_Name Email_Addr
Atkin, Joseph (e-mail address removed)
Corson, Judy (e-mail address removed)
Freilly, Nancy (e-mail address removed)
Holmes, William (e-mail address removed)
Koches, James (e-mail address removed)
Llamas, Frank (e-mail address removed)


Selected values fom drop down list
Approver_Dept Approver
Rcd#1 Program_Control Holmes, Wiliam
Rcd#2 Operations Llamas, Frank
Rcd#3 Engineering Corson, Judy


The user can select different number of approvers depending on how big the
project/contract is. It has a minimum of (3) approvers. I need to capture
all the selected approver names from the repeating table section and then
link the list to the SQL view, vw_empl to get the corresponding email address
that I can concatenate for the To_email value when the submit button is
clicked.

Will appreciate a detail solution since I am new to Infopath. TIA.

 

[S.Y.M. Wong-A-Ton]

I haven't tried this myself, but it should work, at least in theory.

Try the suggestions from this blog post to generate the "To" field for the
email: http://blogs.msdn.com/infopath/archive/2006/04/05/569338.aspx

Instead of the textbox containing the email, you can use your drop-down list
box bound to the SQL view and use the person's name as the "display field"
and the email address as the "value field" for the drop-down. This way the
values (=email addresses) will be used when generating the concatenated email
"To" field string.

 

[Tony]

Is there anyway i could get the same solution to work in c# manage code?