Help - dynamic drop down list generated from data in previous field
Hi thanks in advance. I am writing a database in which I would like the user to be able to enter names with EITHER typing or an "intelligent" drop down list. So, for example, if he types in the Surname field "Jones", the first names of all the "Jones" so far in the database will populate the drop down list in the First Name field for him to select. If there are no Jones then nothing happens and the user can proceed to type in the First Name manually as well. I want this to happen seamlessly in the background and as soon as the user hits the TAB key to exit the Surname field, without needing to click on a button to do a search or something like that, which would make the interface too clumsy.
I figure that this would be a neat way to cut down the length of the drop down list to just the relevant entries in the database, but can't figure out how to make this happen.
Any help or pointers in the right direction is much appreciated,