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.