I had a list with 18 lookups which exceeded the SharePoint 2010 threshold. So I broke it up into 3 lists all having the same "ProjectID" column as a lookup to the first column so that there is only one row of data for each ProjectID in all of the lists. What I need now is nice way to present all three lists for managing them. Or is there a better way to handle this?

  • How many fields total did you have in this 1 list? 18 lookup columns seem like a lot so I'm curious as well what each of these is for.
    – skeletank
    Nov 5, 2013 at 14:20

2 Answers 2


You could consider either building a InfoPath form and using those lists as secondary sources for look-up data, or using the Linked data source with a DataView web part - however not sure you could also enable editing (http://office.microsoft.com/en-us/sharepoint-designer-help/add-a-linked-data-source-HA010355748.aspx).


you could try what this guy has stated:

Combining multiple lists into one

hope it helps :)

  • 1
    Please don’t add just a link as answer to a question. If the link breaks, the answer you provided will not be useful for future visitors. Provide an answer of your own and use the link as reference. If needed, you can block quote the content from your link. More information is found in our help center, especially How do I write a good answer
    – Benny Skogberg
    Apr 15, 2014 at 6:29
  • @BennySkogberg comon this is an old question over a year ago and the link is on the same site!
    – Ali Jafer
    Apr 15, 2014 at 7:27
  • Since I'm one of the "protector of content", you'll see this types of comments on old answers too Ali! ;-)
    – Benny Skogberg
    Apr 15, 2014 at 7:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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