I have a lookup which looks at a list of clients and project numbers, and is rather large (around 500 and growing), and I was wondering if there was anyway to search the results of the list lookup rather than just having one giant dropdown?
Prefer an OOTB solution if possible as we're using Sharepoint online (365)
The other option would be to have a cascading list so that we could choose 'Client A' and then only see related projects in the next drop down for client A - but again this seems to involve 3rd party addons/behind the scenes code.
This lookup will be used on multiple lists eventually