Good Morning, 

I have several SharePoint lists that utilize another list as a lookup for the names of individuals (hundreds). Those names may or may not be on the other lists but they are available from the lookup column. I am trying to create a form where the lookup column with the names exists on the page and when a name is selected the specific list they are looking at fills the data on that individual. I can populate the dropdown easy enough but trying to query the list by filtering on the user name is proving a bit more challenging. Has anyone worked through this process before and can give me some tips or ideas?

Thanks,

Ben