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.