Traci, For the recordset that you already have.
Pipe_id File_id File_title ===================================== 98991 0 proposalrevision.doc 98991 0 tableofcontents.doc 98991 1 visio.vsd 98991 2 08fmla.doc 92874 0 allergies.ppt 87171 1 statementofwork.doc 45663 2 debrief0999.pdf You can just output it like so, without grouping in the query itself. <cfoutput query="MyQry" group="Pipe_id"> #MyQry.Pipe_id#<br /> <!--- This will display once. ---> <cfoutput> #MyQry.File_title#<br /> <!--- This will display all the documents associated to the Pipe_id ---> </cfoutput> </cfoutput> HTH Chuck ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326246 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4