I've got the following scenario: List A contains several thousand items, List B has a lookup field to List A. When a user is creating item in List B she has to select the List A item via the mentioned lookup field. Additionally, when creating List B item user has to choose "Sector" value which could potentially limit the number of items in the drop down list.
The issue I am facing is the number of records the user has to go through to find the one she is interested in. I was trying to find any solution, but I did not find anything. Do you know if there is anything that I can do to help the user to find the relevant item? I was thinking about some kind of a search option or choosing the item from a webpart instead of a simple drop down list. If this is not possible, how can I implement the following mechanism: user chooses the "Sector" which acts as a filter for the lookup field?
Any help will be appreciated.
Lukasz