I have a [Customer Code] list which lists every customer, their address and bank codes.
The list has grown beyond the 5000 (LTH) and users cannot now open it.
As it is not recommended to override he List Threshold Setting of 5000. How would the experts manage this list so that customer records can be quickly found/viewed/edited and new records can be added.
(I was thinking folders A-H, I-P, Q-Z although I prefer to avoid folders in SharePoint as it defeats the meta data capabilities).
At the moment it is just one link on the Quick Launch to the whole Customer Code page (in Data Sheet View).
Note: The whole list will still need to be exported to Excel occasionally, which as the Administrator I can still do (well, until the list reaches 20000!).
Thanks for your time