I'm working on script for a basic form. On that form, there is a Lookup Field that connects to a form in another database. I'd like to pull-in information from the form in the other database based on what's entered in the Lookup Field, is that possible? Here's a bit more detail:
There is a Task form. It has a multi-select Look-up field: Person(s) Responsible. The dropdown menu for that look-up field (Persons Responsible) is based on a Team Members form in another database. Included on the Team Members form is the person's email address. For each Person Responsible on the Task form, I'd like to grab their email address from the Team Members form.
Thanks!