I have a query that pulls member information, including typical info such a name, address, etc - each member can belong to one or more clubs and can also be in one or more volunteer capacities
There are 5 tables: Members - basic member info Clubs - list of clubs Volunteer categories - list of volunteer categories Volunteer inking table - links member id to one or more volunteer categories Club linking table - links member id to one or more volunteer categories Grouping by clubs OR Grouping by volunteer categories is not problem using the group="club" for example within the cfoutput tag. The challenge comes in when I the want the volunteer category to also be displayed for each member.. I've tried this, but it outputs the volunteer and club categories twice for each member: <table border="1"> <cfoutput query="get_members" group="member_id"> <tr> <td>#member_id#</td> <td>#fname# #lname#</td> <td><cfoutput>#club# (#club_id#)<br></cfoutput></td> <td><cfoutput> volunteer category:#category#<br></cfoutput></td> </tr> </cfoutput> </table> any suggestions would be appreciated Tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212814 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54