I have two tables, departments and marks. The department table has information for more than one department. The mark table holds all marks for all subjects in all departments. The department layout has a pop-menu shows all subjects in that department. when I select a subject to see all student marks in that subject in another layout which has a portal based on marks table. The problem is that the portal always shows the first subject marks.
any help please would be very appreciated
Many thanks in advance.