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

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?

share|improve this question
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 '13 at 14:20

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 (

share|improve this answer

you could try what this guy has stated:

Combining multiple lists into one

hope it helps :)

share|improve this answer
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 '14 at 6:29
@BennySkogberg comon this is an old question over a year ago and the link is on the same site! – ali Sharepoint Apr 15 '14 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 '14 at 7:43
lol thanks ;) gl – ali Sharepoint Apr 15 '14 at 7:45

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.