Lookup an email address in another form based on dropdown selection.

Lookup an email address in another form based on dropdown selection.

I have 2 forms.

Form 1 is a Sales_Rep form with 3 fields: Name, Email, and a checkbox for current employee or not.

Form 2 is a Job form with many fields. One of these fields is a dropdown lookup of Sales_Rep.Name.

In the "Form Actions, On Success" deluge script of Form 2, id like to send an email to the Sales_Rep.Email of the selected Name. Im unsure of how to declare this variable.