1 Reply Latest reply on Jul 18, 2011 4:22 PM by philmodjunk

    FMP equivalent to "collections" in Bento

    mattatobsidian

      Title

      FMP equivalent to "collections" in Bento

      Post

      Hello,

      I have a table called, "Submissions" that displays information about creative talent that has been put up for particular jobs [directors, editors, musicians, etc]. The fields are essentially: Date, Agency, Client, Project, Director*, Viewed?, Notes. I would like to essentially create collections that show just the directorial talent, just the editorial talent, and just the music talent. I've tried to create multiple layouts, but once I've used a field, say "Agency" it won't let me make another "Agency" field [understandable]. Any thoughts?

        • 1. Re: FMP equivalent to "collections" in Bento
          philmodjunk

          Add a single text field called "category" or some such descriptive field name.

          In each record of this table enter text into this field to identify the record as "Director", "editor", etc. To display all records in the "Director" category, you'd then either perform a find (on a layout based on this table) or set up a filtered portal that filters the portal records to only display records in the "director" category. While you could set this up with different layouts with a different filter on each portal, you can also add a field to your table and to the layout where you use a value list to select a category, then your portal expression compares portal records to the category selected in this field to control which records are displayed.

          Note sure why you want to add a field named "agency" to the same table more than once...