SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The problem with the standard SharePoint Multi Lookup Field is that I can't store more that 400-500 values in it because of the certain SPListItem limitations. We need to store at least 1000 lookup values per field, possibly more. I am about to start developing a custom field that stores the values in a database table. This field will be very complicated to develop. So, I've searched on the Interned just in case someone already did similar field in the past and found nothing.

Are there any database-based milti lookup fields you know or heard about?

share|improve this question
up vote 0 down vote accepted

did you mean that you need a field type like the User field?

try to google sharepoint entity picker

share|improve this answer
Yes, this is a very nice control. I might even end up using it, but it has two fundamental problems i'm trying to solve: 1) It becomes impossible to work with if you have about 500 items selected and and want to delete one or two 2) validation of about 500-1000 SharePoint items will end up with timeout what is exactly the case with iLoveSharePoint's extended lookup with picker: I'm trying to store all data in SharePoint lists. The only thing I need to store in a Database is Lookups. – Denis Molodtsov Aug 16 '13 at 13:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.