I want to suppliment CFLDAP Employee data with images of employees and display
them on a page. I could just name the images the same as the CFLDAP Unique ID,
but I also need to use an MS Access table to group the names for teams. I have
been trying to create a relationship between my CFLDAP query and my CFQuery
using CFLOOPS, but cant figure this one out. Please help.

<!--- request data from ldap --->
<CFLDAP NAME="GetEntry"
SERVER="******************"
PORT="******************"
ACTION="query"
FILTER="ou=*EPS MIBU T&M EVEREST PROGRAM*"
START="******************"
SCOPE="subtree"
ATTRIBUTES="uid,cn"
SORT="uid">

<!--- query from MS Access Db --->
<CFQUERY NAME="photo_query" DATASOURCE="#Application.DSN_GTIS#">
SELECT uid, photoID, team
FROM photo_tbl
WHERE uid= #GetEntry.uid#
</CFQUERY>

<!--- Output --->
<table border="1">
<CFLOOP query="GetEntry">
<CFOUTPUT><tr>
<tr>
<td>
#GetEntry.cn#,
#GetEntry.cn#
</td>
<td>
#photo_query.photoID#
</td>
</tr></CFOUTPUT>
</CFLOOP>
</table>