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?
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:
hope it helps :)