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 have two lists: list A and list B. List A should have a new multiple choice lookup column that allows the user to choose items from both list A and list B. Is this even possible? I have a kind of idea how to make a custom ASPX form in which the user would be able to choose from both list A and list B items, but I am completely clueless on how to make that multiple choice lookup column save a link to the list item located in the list B.

Thanks.

Edit: There is one restriction; this multiple choice lookup column needs to be filterable in the list A view.

share|improve this question
add comment

2 Answers

I would go for NO, not actually possible unless you build your own custom field to merge from 2 lists and display the Union/Intersection of values with appropriate storage of data. Even so, you would have to deal with storing the lookup value (ID#Value) combination which could also generate improper lookup due to duplicates.

There is another way to merge data from 2 columns, and that is by using the DataView Web Part in SharePoint Designer and Linked data sources, see here http://www.dotnetcurry.com/ShowArticle.aspx?ID=581

share|improve this answer
add comment

The is no OOTB support for having multiple sources. Your options are:

  1. Merge List A and List B into one list with different content types
  2. Create a BDC model in Visual Studio getting it's data from the two list, create a External Content Type and external list based on that model
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.