1 Reply Latest reply on Aug 20, 2012 6:04 AM by philmodjunk

    Relationship not evaluating

    beckett85_1

      Title

      Relationship not evaluating

      Post

      Currently have a system where filtered client notes are not evaluating from an extra table (Worked in FMP 11 but not in FMP 12)

      Say for example we have 3 tables

      Clients
      Notes
      Facilities

      where facilities and notes are linked to clients, to filter records in the portal quickly i setup a global calculation and a global under clients for the departments (ie. Marketing & Operations) instead of doing portal filtering which was too slow on sorting

      The global calculation along with the client ID links to the Notes table

      If the global field is empty, the global calculation will list ALL departments (for example if you select marketing it will equal Marketing, if you select nothing it will equal Marketing & Operations (as 2 values)

      If you are on a layout based on the clients table it filters fast, and it's all fine, If you are on the Facilities table and try and you dont select ANYTHING in the global field, the calculation still evaluates, but the relationship doesn't, thus if you DONT select any values you will not be able to see any notes, but if you select all values manually, you can see all notes, even though BOTH methods result in the calculation field evaluating the full list

      Apologies if this doesn't make sense!

       

      Anthony

        • 1. Re: Relationship not evaluating
          philmodjunk

          There are details missing. What is the relationship between facilities and clients?

          What is the precise relationship between clients and notes?

          is it this?

          Clients::CalculationField = Notes::Category and
          Clients::ClientID = Notes::ClientID

          And is the "global calculation" an unstored calculation or a global calculation? If you selected global storage, change it to just unstored.