I have one list with 11 columns.From 11 columns 10 columns are multilookup.On clicking on new item it doesnt show some fields multi lookup.
Is it possible to have 10 multilookup columns in one list in sharepoint and it will show all fields multilookup?
I have increased resource throttling limit but it is not a good way as it slows sharepoint server or I have to distribute these columns in two list.
If  you are using  SharePoint 2013 .. You can apply – June 2013 CU update and try . List view threshold has been revisew to 12.
Also if posiible try to change some columns to Choice fieldsÂ
Thanks Jorge for commenting I have tried the same but after changing resource throttling limit also,some multilookup fields are not visible.
Prasad,
By default, the lists have a limit of 8 lookup colums they can show in a view. This limit can be modified in Resource Throttling en the section List View Lookup Threshold.
But you can add all the lookups you want to a list if you don’t show more than 8 in the views.
If the lookup columns queried against lists that have more than 5000 items (or your threshold list view) , in the new form, you will find that these columns can not be updated and they show a message instead of the controls.
Thanks for reply Ajeet. I am working on customized solution. Using second option seems very bad practices. Because let say if I works on simple asp.net project and sql as backend then we don’t create 2 tables in same case (If I am not wrong) . Is there any other provision available in SharePoint to handle such condition?Â
