How do I use something like a drop down list to locate a record?
I have a "data entry" layout to enter/edit records in a table. The table contains over a a thousand records so I need a mechanism to locate the record to be edited. The format of a drop down list is OK but that appears to be for data entry. I want to be able to select or highlight the name in the drop down list and use that input to go to the indicated record. My list or "index" includes, among other fields, names and record numbers. So when a name is selected, the script can immediately bring up the selected record. There must be a straight forward way to do this.