How do you set up portal filtering to filter by more than one field?
I have a table containing student records (STUDENTS). A separate table contains their grades (GRADES), each record is a grade for a particular session.
I have a layout based on the STUDENTS table. It has separate tabs that each contain a portal listing the GRADES records for a particular course. The portals currently filter for the course code but I want to be able to filter for both a course code AND a session type. Both of these fields are on the GRADES table so I thought this would be simple.
What am I missing?