Counting related records of a particular status

Discussion created by ChrisG on Feb 27, 2014
Latest reply on Feb 27, 2014 by Mike_Mitchell

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.