I am experiencing a problem regarding lookup columns.
So the problem is that i have a list (list X), with a lookup column pointing to relating documents (list Doc). The X list itself is sitting at 400 items, but the Doc list is all ready sitting at 5200 items.
Now the lookup column which was pointing to the documents ID's is no longer working.
Is there a work around for this problem as i am aware that the Doc list item limit threshold can't be increased and to make use of views limiting the list is also out of the question as lookup columns can't point to a specific view.