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.– skeletankNov 5, 2013 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 (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 :)
1Please 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! 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