This project has moved and is read-only. For the latest updates, please go here.

Filtering a single look up field based on a specific record's multi lookup field in a form

Jul 27, 2012 at 3:16 PM

I have a list of people with a multi-lookup field called licenses to the title field in a list called licenses. I have another list called submissions that has a single look up field called person to the title field of the people list (person's name, text field), as well as a single look up field called license to the title field of the licenses list. 

I want to filter the Submission new form's license single look up field to only show licenses that exist in a specific person's multi lookup licenses field. (Specified person could be obtained through current user or querystring, doesn't matter right now).

I thought about using SPFilterDropDown but I don't think it works in the way I'm trying right now.

Jul 30, 2012 at 7:57 PM

I'm not sure I totally get what you're trying to do, but SPFilterDropdown *may* work. It sounds, though, like your needs are a bit different than any of the existing SPServices functions.