Email Contact from a 'Value List'
I am farely new to FileMaker and am using FileMaker 10 Pro. I have a drop-down menu right now that is using a value list of email addresses. When an email address is selected from the drop down an email is sent to that email address. I would like to display each persons name in the value list (instead of the email address) and then have the email sent to that person that is selected. I cannot figure out how to tie the persons name (that will be showing in the drop-down menu) to an email address. Any suggestions?