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