3

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

Improve this question
8
  • 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. Commented Apr 24, 2012 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? Commented Apr 24, 2012 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/… Commented Apr 24, 2012 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 Commented Apr 24, 2012 at 13:53
  • @RyanS I can't find anything that helps me allong. But if you like I post the code Commented Apr 24, 2012 at 14:51

2 Answers 2

Reset to default
4
+25

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.

Improve this answer
1
  • Nice, this totally worked :) Great work, Frederik! Commented Apr 26, 2012 at 15:13
0

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

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.