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

our setup for document library as follows. We have bunch of document sets (200 doc sets to be exact) in a document library. Each doc set is for particular vendor. We place contracts in each document set. Now when it comes to renew or amendment or work order we need to be able to tie to the main contract type.

I enable SP doc id. I created a lookup column that will look inside this library and show all the items.

But I need to be able to filter this list. I only want to show the items in the given document set (instead of showing all the items from the document library). Also, I need to be able to show (ID - Title) in the drop down. Just showing ID in the drop down user wont know what item it's tie to.

Hope I am making sense.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

There is CodePlex project I used to solve something similar: Lookup Field with Picker 2010

Features

  • Single- and multi-Selection Mode
  • Cross site picking
  • Search in picker dialog
  • Search Operators: equals, not equal, contains, begins with, greater than, greater or equal than, less than, less or equal than.
  • Select fields you would like to search for.
  • Relationship behaviors
  • Supports default values (constants, current user id and default values by url param, useful for 1-n scenarios) must be configured via PowerShell
  • Languages: English, German
  • Delivered as SharePoint Solution Package (WSP)
share|improve this answer
    
Thanks for the quick reply. I will try this. Thanks –  Mary Rivers Sep 9 '11 at 14:08
    
Lookup with Picker works. However, 3rd party (like SP Boost or Knowledgelake or Nintex) are not recognizing this custom filed. Now what? –  Mary Rivers Sep 19 '11 at 13:01

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.