This may be hard to describe what I'm trying to do. I have a database table called assignments where there are columns: section, team, and candidate.
For each section, there are 3 teams- 1, 2, 3. The sections are listed alphabetically from A-V. There are 5 candidates per team, so a total of 15 per section. I need to display this for a printer friendly page using dynamic text. For instance:
Candidate_1 Candidate_2 Candidate_3 Candidate_4 Candidate_5
In the database, each candidate has their own row. Modifying the table structure is not an option. Is there any way to pull all candidates from a specific team from different rows to be displayed? Many thanks.