regarding item 2; there is a way to, as you type in a few characters, to have
selections become available based on the 'partial match or matches' that meet
the characters that have been typed so far. I had a project 2 years ago that
used this type of logic.