Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I need to create a list column which contains external data (from BDC). The field has to contain multiple values. But I haven't found a way how to make a external-data-field take multiple values.

Creating such a multi-value field is possible by using the Column-Properties "allow multiple selections" in a user content type. However, creating a column using external data I do not have the ability to add a multi-value column.

It should look like this, just from a external data source (BDC/BCS): multi-value field

Does anyone know how to handle such a situation?

My Environment: SharePoint 2010, Visual studio 2010, SharePoint Designer

share|improve this question
    
Can you get the standard and limited form code? So we can compare the two; it's likely theres a little change you can make to your current form. –  RyanS Apr 24 '12 at 13:06
    
Do you mean the code from the "NewItem" and "EditItem"-forms? Until now I'm using the standart forms. Sorry, I can't follow, what do you recommend to combine? –  MOI Apr 24 '12 at 13:14
    
I believe this question addresses the same point sharepoint.stackexchange.com/questions/26910/… or if you want the InfoPath way, see here aanuwizard.wordpress.com/2010/07/11/… –  C. Marius - MVP Apr 24 '12 at 13:23
    
I mean the snippet for the form that allows you to select multiple selections, and the form that only allows for one. There may be a simple change in title etc –  RyanS Apr 24 '12 at 13:53
    
@RyanS I can't find anything that helps me allong. But if you like I post the code –  MOI Apr 24 '12 at 14:51
show 3 more comments

2 Answers

You can not allow multi values when using a lookup to a external list.

http://i48.tinypic.com/19w9k0.png

More info about BCS and its limitations can be fount at:

http://www.slideshare.net/orbitone/share-point-2010-bcs

http://www.sharepointanalysthq.com/2010/07/bcs-external-list-limitations

Maybe, you could be able to work around this issue using custom field types for example. But not with OOTB BCS.

share|improve this answer
    
Nice, this totally worked :) Great work, Frederik! –  Ruben Herman Apr 26 '12 at 15:13
add comment

OOTB SharePoint Lookup does not supports it. You can try to use commercial add-ons. For example, Sparqube Lookup Extra field type allows multiple values when lookup items from External List. http://www.sparqube.com/SharePoint-Lookup-Column

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.