How can I combine multiple Lists into one view for editing

Question

I had a List with 18 lookups which exceeded the SP2010 threshold. So I broke it up into three 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 Project Id 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?

Bismarck

Answer 1

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).

Answer 2

you could try what this guy has stated:

Combining multiple lists into one

hope it helps :)