Filter Portal thru a join table?
I have 3 tables:
- Submissions (a join table between Projects and Works)
- Works (all the works submitted to a certain project. Each work has assigned a type (a Writer Submission, Director Submission or an Actor Submission)).
I currently have a layout that lets me view a particular Project, and see all the related Works (via a submissions portal). What I'm trying to do is filter this portal so that I can select to only view a particular submission type (ie "Writer Submissions, ..).
I'm extremely green on calculations and global fields in which I've been trying to mess with, but I'm not getting the results I'd like.
Any help or a link in the right direction would be wonderful!