Search Field In Different Form To Prevent Duplicate
I have an application where I am tracking whether or not a student attended a training. I have a one to many relationship between the student form and the training form based on a field called student name (a concatenation of Last Name, First Name and Middle Initial) I know we can do lookup as a drop down, but is it possible to do it as a search field. In other words I type a few letters of the last name and it searchs for possible matches. If it doesn't find any, it allows me to add them as a new student in the same form.
Thank you,
Tracy