I'm using SharePoint 2013 (Office 365).
I have created a List to store details of our Projects. The Project list has a column which stores the current status of the project. This is a drop-down field containing things like 'Potential', 'Current', 'Archived'.
I have also created a document library for 'Sales Documents'. I have added a metadata column which is a lookup based on the Project list. The idea being I can add a proposal document and link it to the relevant project.
What I want to do now is create a view on the document library which will only show documents that are related to, for example, projects whose status is set to 'Potential'.
Any help in achieving this would be appreciated!