Has anyone done anything like this? I'd rather not reinvent the wheel.
I would like to bring up a city name as the user types, and when a match
appears allow the user to press [enter] to save it or keep on typing if
it is a new city. I've got insert after and update after triggers to add
a new city to a table if it isn't already in it. I tried using a right
click eep on the field, but it's not elegant.
eg. In my city list I might have
Seattle
San Francisco
Sparwood
San Jose
User presses S and all show
User presses A; Sparwood and Seattle disappear
user presses n,<space>,f and only San Francisco shows
user presses [enter] to select or keeps typing for a new city San
Fernando, pressing [enter] when done.
Albert
