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?