I am doing data entry into a form that was created by someone else, and on the form is a lookup box that I can use to reference a table that contains names I need to use to create a more complex record in a different table.
When I type in a name, the lookup will only go to the first appearance...