i have a customers table and i want to display a total count of all this customers projects that are "open".
so a execute sql works well as it lets me specify a criteria for the projects.
e.g select count(id) from projects where status='open' and customer_id=?thiscustomer.
However i wondered is there a FM function that achieves the same thing, without making relationships etc.
The only reason i ask is that i like to avoid execute sql if its easy to do so for the only reason that if field names change then its hard to remember to change it everywhere..