Auto-populate selection from sub-form
I have two forms, one being a series of art works, the other being a list of experts who may write about it. I want to assign multiple experts to a work and then have a "confirmed" check box next to it.
To do this, I created a form called Expert_Assigned, consisting of a look up field and a sub-form.
The look-up field allows a drop down list of all of the art works. I select one.
The sub-form pulls from another form called "Experts". If I type in a name, it adds it to the "Experts" list, which is fine, but if I want to assign an expert to multiple work, I would like the already entered expert to pop-up and auto populate both fields - First Name, Last Name.
How do I do this so I don't have multiple "Experts" with the same name?