>This seems SOOO easy, and I'm about to kill myself. > The answer Kris gave is exactly right.
Your first cfoutput told cf to output unique values of the first field. The second cfoutput told cf to output unique values of the second field. But a third cfoutput is required without a group attribute in order to output all of the child records of the second group. I wrote a rather lengthy (but detailed) blog post about this very subject if you're interested in chewing on it; it may clear up some of the mud or even open some people's eyes to leveraging one of cfoutput's lesser used attributes. http://www.dougboude.com/blog/1/2006/07/IF-THE-SOLUTION-IS-NOT-BEAUTIFUL-THEN-IT-IS-WRONG--STYLE-ELEGANCE-AND-EFFICIENCY-IN-CODE.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247254 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
