I have a list of customers that has 13,000 unique entries and three columns, one for "Customer Number", "Customer Name" & "Region". I need to use this list for various resources in my SharePoint site such as, a Document Library that has a Lookup column for selecting the Customer Name, a List for Customer Complaints that has a Lookup column for selecting the Customer Name etc.
These lookup columns are looking-up against the Customer Name column in my Customer List. However, I have run into a List View Threshold issue as the number of customers exceeds the 5,000 LVT limit.
My site is hosted on Office 365, SharePoint Online so there is no way to increase the LVT.
If I try to upload a document to the doc lib or try to create a new item in the Customer Complaints list, the drop-down list for the Customer Name is not available, just a message saying the list exceeds the LVT. This works fine when there is 5,000 items or less in the list, I click to upload a file or create a new item on a list and I can select one of my customers from a drop-down list. However as soon as the list goes to 5,001 items or greater, the LVT error message appears.
As I have over 5,000 unique customers in this list and need to be able to select from all, I am stuck on how to get this working. Short of splitting the list up into different lists, each below 5,000 items, then adding multiple "Customer Name" drop-down/lookup columns on the required library or list, which I'm sure all will agree is not really a good way to achieve this, I don't know what else I can do to get this working.
Any advice on how to get this working would be very much appreciated.