I’m looking to see whether there is an easier way to automate a task I am currently going to have to end up doing manually.
I have a list which contains all of the companies suppliers, I then have another document library which contains audit information that gets constantly updated. Whenever a new audit report is added to the library a set of information will be included, one of the pieces of information is a look up to the supplier list looking for the supplier name.
What I want to be able to do is have it so that whenever a user clicks on a supplier in the first list it takes them to a standalone page for that supplier and contains a set of different document views which pulls in all the various audit reports from the document library specific to that supplier.
I was just going to do this manually for each supplier, but I’m hopeful there is an easier way to do what I want to do?
I am using SP2013