I'm having troubles with finding a solution (ootb would be best) to have a Master SP List with 3 "sub-lists", i.e. lists showing data from the Master list with a certain value in one of the columns.
The idea is to have one Master list where summary data for 3 different projects is inserted weekly (with attachments) - this list could be accessed only by people entering this data. Moreover, there would be 3 separate lists showing weekly data only for each of these projects.
Is there an easy way of implementing something like this?
I can only think of two ways to do it:
1) Creating the Master List and then Site Pages with filtered List Web Parts - but I don't want people to be able to access the Master List, so this is probably not good.
2) A linked Access database with a query to update the 3 lists based on data on the Master list. This would need to be done manually each week. Also not the best option.