Hi
I have an application where users can vote on about12 different topics on one page by selecting values from one of two picklists, not linked to each other but stored in tables in the DB
I need to make a list page that shows me the top 3 choices for eachcategory, sorted in order of the number of votes gained.
I can produce a query for a single category that shows me the number of votes cast, the name of the person voted for ordered by the number of votes cast.
Do I need to make a separaye page for each voting category?
Can I get all the results in one page?
do i use the query mentioned above as a sub-query for each category>
All help much appreciated, as always.
Cheers