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.

2 Answers
2

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.