Access corresponding column for select
I have a drop that sets the value=id and name to be display in the dropdown. See attachment app.zip.
There's also another column called email which am trying to send an email to email address according to the id that's select in the drop. It keeps sending to the same address.
Any assistance will be appreciated.
Thanks