3 Replies Latest reply on Mar 30, 2010 11:48 AM by philmodjunk

    Filter Portal thru a join table?



      Filter Portal thru a join table?


      I have 3 tables:

      • Projects
      • 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!


        • 1. Re: Filter Portal thru a join table?

          All recent versions of filemaker:


          Define a global field in your join table, gType.

          Make a second table occurrence of Works, FilteredWorks.


          Define a new set of relationships:

          Submissions::WorkID = FilteredWorks::WorkID AND

          Submissions::gType = FilteredWorks::Type


          Place a portal to FIltered works and gType on your Projects Layout.

          Enter different types in gType to see a different sub set of works for the project appear in your portal.


          In Filemaker 11:

          You can simply select the filter option for the portal and use Submissions::gType = Works::Type as your filter expression to get the same results without needing the extra table occurrence.

          • 2. Re: Filter Portal thru a join table?

            This is perfect Phil! Thank you! It worked!


            Is there a way to type in something into gType field to "show all" (I intend to putt a value list to select the work types)?

            • 3. Re: Filter Portal thru a join table?

              With a bit of trickery, you can do this.


              Define a calculation field in Works:

              "Show All¶" & Type


              Match gType to this field instead of Type.


              In filemaker 11, your filter expression could be: gType = "Show All" or gType = Type. (and you don't use the extra calculation field.)