this is as close as i can get... http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid07.cfm not quiet there.. i know it has to be something relatively simple!
any more help would be fantastic! -paul <cfquery name="rsEmployee" datasource="ISresource" dbtype="ODBC"> SELECT EmployeeID, LastName, FirstName FROM tblEmployee ORDER BY LastName; </cfquery> <cfquery name="myRelations" datasource="ISresource" dbtype="ODBC"> SELECT Relation_ID, tblRelations.Service_ID, tblRelations.EmployeeID, tblService.Service_ID, tblService.Service, tblEmployee.EmployeeID, LastName, FirstName FROM tblRelations, tblService, tblEmployee WHERE tblRelations.Service_ID = tblService.Service_ID AND tblRelations.EmployeeID IN (tblEmployee.EmployeeID) ORDER BY Service, LastName;</cfquery> <cfscript> rsEmployee_NumRows = 0; rsEmployee_Index = 1; HLooper1_NumRows = 20; rsEmployee_NumRows = rsEmployee_NumRows + HLooper1_NumRows; </cfscript> <table border="1"> <tr> <td bgcolor="#C0C0C0">Service</td> <cfloop query="rsEmployee"> <cfoutput> <td align="center"> #LEFT(rsEmployee.FirstName, 1)#.#LEFT(rsEmployee.LastName, 1)#. #rsEmployee.EmployeeID# </td> </cfoutput> </cfloop> </tr> <tr> <cfoutput query="myRelations" group="Service"> <td>#Trim(myRelations.Service)#<br> <!--- shows who we have in there ---> <cfoutput group="LastName"> <strong>#myRelations.EmployeeID#</strong><br> </cfoutput></td> <cfif rsEmployee.EmployeeID NEQ myRelations.EmployeeID> <cfloop query="rsEmployee"> <tD><em>#EmployeeID#</em></tD> </cfloop> <cfif myRelations.EmployeeID NEQ rsEmployee.EmployeeID> <cfoutput> <td><strong>#EmployeeID#</strong></td> </cfoutput> </CFIF></CFIF> </tr> </CFOUTPUT> </table> ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists