I've got three screens connected to three different databases:
Screen 1 connected to dbo.Students
Screen 2 connected to dbo.CourseTitles
Screen 3 connected to dbo.Enrollments
I have a form for Screen 3 with fields for Student and Course Title. I want to have a text box in this form where I can begin typing a student's name from dbo.Students and get a list of options to choose from. Example: type "Dav" and get a list of David, Davis, etc. Then choose the student and the course title and submit the form.
If I use a Drop Down box, I don't think I would be able to filter by typing the first few letters of the name to find the student I want.