AnsweredAssumed Answered

Question re: election results database

Question asked by nate1604 on Sep 6, 2009
Latest reply on Sep 14, 2009 by TSGal


Question re: election results database


I am utilizing FMP 10 Pro to analyze election data.  My database contains precinct-level vote totals for a single election contest with 8 candidates.  The database has four fields:  "PRECINCT", "CANDIDATE_NAME", "TOTAL" and "pk_Serial".

For each of the 8 candidates, the database displays vote totals for each precinct within the county.


Somehow I need to devise a process which lists the winning candidate for each precinct in a separate field. Any thoughts on how to go about doing this?