How to pull data from drop down lists?

Discussion created by samcourtenay on Nov 20, 2014
Latest reply on Nov 23, 2014 by samcourtenay



I run a cleaning company and use FM13 as my database.


each record is a job, one of the fields I have made is "LEAD" this is a drop down list where we select we the customer heard of us e.g. repeat client, yellow pages, google, etc


After searching for all jobs done in a month I manually count each lead type and enter it into my monthly report.


Is there a way I can script it so that FM can automatically counts each lead type and put those totals into separate boxes?