I am trying to create a multiple choice field for e-mail addresses. What i want to do is create 5-10 "email fields" on my "client" table named Email #1, Email #2 and so on. Then when someone goes to create a "ticket" and they select their client, i would love to be able to give them a drop down selection of all the e-mails listed in client table for that particular client. the reason for this is so we can choose who to send the email notifications to.
Is this possible? i have done a lot of research on the forms here and i can't seem to find anything relating to this.