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.