5 Replies Latest reply on Nov 23, 2014 1:52 PM by samcourtenay

    How to pull data from drop down lists?




      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?