Hi people,

I've been trying to figure out the following for a while, hope you guys can help me out here.

We've created a BizForm which allows users to register for a course.
The registration needs to be sent to an email adres, which we can set in the CMS Desk under 'Tools' -> 'BizForms' -> 'Notification e-mail' -> 'To e-mail'.

The e-mail address however is not supposed to be static. Our BizForm includes a dropdownlist filled with a list of locations where the specific course is given and since each location uses a different e-mail address we want to fill the 'To e-mail' field with the e-mail adress from the selected location.

In order to retrieve this specific e-mail address we need to execute a query on our SQL database (we have two custom tables 'Content_course' and 'Content_location'.

We've tried using a hidden dropdownlist with a SQL query and Custom macros, but neither of those two worked.

Could anyone help us with this problem.

Thanks in advance!