Getting Started with Access Lookup Wizard Fields

[Mike_x27]

Hi There,
I have an Access database with 2 tables.
One Table is used to store nothing but Names.
My goal is build a simple database to track information regarding assignments
given to our interns.
I have it working in Access and wish to convert it cold fusion.
Most of my fields are simple text fields and check boxes - no problem there.
Right now I am stuggling on how to display data in an access Lookup Wizard
Field in an CFOUTPUT.
Instead of displaying the name of the intern I want displayed, I am only
seeing a number (I think It is the Primary Id of field of the record int the
Names Table.
How can I tell CFOUTPUT to display the text name of the inten instead of its
primary key?
Here is my simple Query:

<cfquery name="Recordset1" datasource=#MM_Interns_dsn_DSN#
username=#MM_Interns_dsn_USERNAME# password=#MM_Interns_dsn_PASSWORD#>
SELECT * FROM intern_data
</cfquery>
<cfoutput query="Recordset1">
#Recordset1.Intern#<br>
</cfoutput>

Here #Recordset1.Intern# is displaying a number ex. "2"
I want it to display data, examle "Smith, John"

Thanks!:confused;

[paross1]

Use the column for the intern name from the intern_data table, whatever that
is. If you want to get an idea of what your query is returning, replace your
CFOUTPUT with a CFDUMP to temporarily see all of the columns and rows returned.

<CFDUMP var=#Recordset1#>

Phil