I have an employee table with first, last & middle name. I need to create a search box where the user will enter part of the last name and all available matches (Last, First, M) will appear in a box. Then the user should be able to select one of the names to query for information.
"Jones, Ben R."
"Jones, Raymond Q."
"Jones, Stacy M."
User clicks on "Jones, Raymond Q." and the main info screen appears for that employee.
Thanks in advance for your help!