ok came into the office to try it out... mucked about a bit... and wasn't able to float it... Isaac you can see a your modified example here... http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid06.cfm
im going home now.. bringing my laptop to hopefully get this working this weekend.. thanks again -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> <cfquery name="rsServices" datasource="ISresource" dbtype="ODBC"> SELECT tblRelations.Relation_ID, tblRelations.Service_ID, tblRelations.EmployeeID, tblService.Service_ID, tblService.Service, tblEmployee.EmployeeID, tblEmployee.LastName, tblEmployee.FirstName FROM (tblRelations LEFT JOIN tblService ON tblService.Service_ID = tblRelations.Service_ID) INNER JOIN tblEmployee ON tblEmployee.EmployeeID IN (tblRelations.EmployeeID) <!--- AND tblRelations.EmployeeID = 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> <!--- Start Wierd CFIF Statemnt ---> <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> <!--- If i coment this output out then it displays the look i want but on shows the first selection in bold!!! <cfoutput group="LastName">---> <cfoutput> <cfloop index="EmplID" list="#myRelations.EmployeeID#" delimiters=","> <cfloop query="rsEmployee"> <cfif EmployeeID NEQ #EmplID#> <tD><em>#rsEmployee.EmployeeID#</em></tD> <CFELSE> <td><strong>#rsEmployee.EmployeeID#</strong></td> </CFIF> </cfloop> </cfloop> <tr> <td></td></cfoutput> </tr> </CFOUTPUT> </table> <br> <strong>Isaac Dealey [code]</strong> <table> <cfoutput query="rsServices" group="Service_ID"> <tr><td>#Service#</td> <cfoutput> <td>#EmployeeID#</td> </cfoutput> </cfoutput></table> ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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