I have got 2 lists call Applications and Vacancies. Application has a lookup filed pointing to Vacancy. And Vacancy list has got a user field called "Hiring Manager". I need to create a view under Applications list and filter this list based on the associated hiring manager from vacancy table. I tried to use Linked datasource, but when I create it, although I select columns, I cannot see anything in the datasource pane.
Could you give me, please, an idea how to create such view?
Thanks