We have over 1900 employees in our organization and at times it is kind of annoying to go through an entire dropdown to select an employees name from a list. What I would like to do is create 2 dropdowns on the form.
The 1st option - The user would select a section of the alphabet (a-c, d-f, etc)
The 2nd option - Would then contain the users name (retrieved from the database) that begins with the letter selected in the 1st option.
Any help would be greatly appreciated.
Thanks in advance