1 Reply Latest reply on Feb 27, 2014 9:04 AM by Mike_Mitchell

    Counting related records of a particular status

    ChrisG

      Dear FMP gurus

       

      I know that this is an old one and that I should know how to do this. I am looking for an elegant efficient way of counting the number of related records where the status is: "complete", "part complete" or anything else the user decides to use as a status.

      These status' are set-up by the user in a preferences table which provide the data for a value list which is used in the status field.

       

      I was thinking something along the lines of listing the value list items in a variable, looping throught the list to set a match field in the relationship, counting the number of related records.. and so on. I can't help thinking that there must be a better way of doing this.

       

      thank you.

       

      Regards

       

      Chris