I have a custom list with multiple fields with data of employees. One of the fields is the employee section. Currently to see employees of a specific section I created 1.A page that has the list of sections with a hyperlink, 2.A page for each section with a web part that has a custom view to show employees of that specific section only.
Now I remember in a dynamic web site using ASP or PHP you could do all this with two pages. One lists the departments and the other one builds on the fly the page you are requesting.
Is this possible using SharePoint where one page will have the section while the second page will have a custom view criteria (Show the items only when the following is true) where column "X" will have the filter of the criteria instead of building a page for each and every section.