2 Replies Latest reply on Oct 7, 2010 12:35 AM by Mastema

    Portal filter (filemaker 10)



      Portal filter (filemaker 10)



      I'm trying to create a filter for a portal, but I seem to be stuck:

      i've got two tables (view an company)

      table view:

      "prospect" as a number (0 or 1) global field
      "one" as a number (global, always 1)
      "companyfilter" as a text (global)

      table company:

      "prospect" as a number (0 or 1)
      "name" as a text
      "calcFilter" as a calculation field ( PatternCount(name; View::companyFilter) ≥ 1), result is number (this works fine)

      If i make a relationship: view::prospect = company::prospect everything works fine: after changing the value of view::prospect, my portal view only shows the ones that match

      If i make a relationship: view::one = company::companyfilter, regardless of the previous relationship, no information is shown in my portal when I change the value of companyfilter...
      Does anyone know what i'm doing wrong?

        • 1. Re: Portal filter (filemaker 10)

          The portal fields used in the relationship must be stored, indexed fields. A calculation field that refers to a field in a different table is by definition an unstored field so your calcFilter field cannot be used in this relationship.

          I'm not sure exactly how you want to use a specified prospect setting and company name setting, but you might try this relationship:

          View::Prospect = Company::Prospect AND
          View::companyfilter = Company::Name

          This allows you to specify 1 or 0 for prospect and then select a company name in the company filter field and your portal will then display all matching values.

          If you want to set up a "partial company name match", in FileMaker 10 and older versions, you'll have trouble doing it. It will be much simpler to upgrade to FileMaker 11 so that you can do this with a portal filtering expression instead of trying to implement this in a relationship.

          • 2. Re: Portal filter (filemaker 10)

            Thanks for the reply,

            I upgraded to fm11 and all works fine now