Kevin & everyone,
Here is the generated code, I only want one CM_ID text box and I want it to have a drop down list showing the CM_ID and the CM_NAME_LAST. I put the CM_NAME_FIRST and the CM_NAME_LAST look up fields on the screen as an act of desperation. I think they are looking up correctly from the CM table which is related to this EM table by CM_ID = EM_CM_ID.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML XMLNS

="urn:schemas-microsoft-com

ffice

ffice"
XMLNS:x="urn:schemas-microsoft-com

ffice:excel"
XMLNS:a="urn:schemas-microsoft-com

ffice:access"
XMLNS:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><LINK
href="./email%20list1_files/filelist.xml" rel=File-List type=text/xml><TITLE>EMAIL_LIST</TITLE>
<META content=Access.Application name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<STYLE id=MSODAPDEFAULTS type=text/css rel="stylesheet"></STYLE>
<OBJECT classid=CLSID:0002E530-0000-0000-C000-000000000046
codeBase=file:msowc.cab id=MSODSC><PARAM NAME="XMLData" VALUE="<xml xmlns:a="urn:schemas-microsoft-com

ffice:access"> <a

ataSourceControl> <a:OWCVersion>9.0.0.3821</a:OWCVersion> <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Program Files\Common Files\ODBC\Data Sources\cardio.mdb;Mode=Share Deny None;Jet OLEDB:System database=&quot;&quot;;Jet OLEDB

atabase Password=&quot;&quot;</a:ConnectionString> <a:MaxRecords>10000</a:MaxRecords> <a:GridX>24</a:GridX> <a:GridY>24</a:GridY> <a:ElementExtension> <a:ElementID>EMAIL_LISTNavigation</a:ElementID> <a:ConsumesRecordset/> </a:ElementExtension> <a:ElementExtension> <a:ElementID>EM_ID</a:ElementID> <a:ControlSource>EM_ID</a:ControlSource> <a:ChildLabel>EM_ID_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>CM_ID</a:ElementID> <a:ControlSource>CM_ID</a:ControlSource> <a:ChildLabel>CM_ID_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>EM_ADDRESS</a:ElementID> <a:ControlSource>EM_ADDRESS</a:ControlSource> <a:ChildLabel>EM_ADDRESS_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>EM_PRIORITY</a:ElementID> <a:ControlSource>EM_PRIORITY</a:ControlSource> <a:ChildLabel>EM_PRIORITY_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>EM_TYPE</a:ElementID> <a:ControlSource>EM_TYPE</a:ControlSource> <a:ChildLabel>EM_TYPE_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>CM_NAME_FIRST</a:ElementID> <a:ControlSource>CM_NAME_FIRST</a:ControlSource> <a:ChildLabel>CM_NAME_FIRST_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>CM_NAME_LAST</a:ElementID> <a:ControlSource>CM_NAME_LAST</a:ControlSource> <a:ChildLabel>CM_NAME_LAST_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>DropdownList0</a:ElementID> <a:ControlSource>CM_ID</a:ControlSource> <a:ListRowSource>EMAIL_LIST</a:ListRowSource> <a:ListBoundField>CM_ID1</a:ListBoundField> <a:ListDisplayField>CM_NAME_LAST</a:ListDisplayField> <a:ChildLabel>DropdownList0_Label</a:ChildLabel> </a:ElementExtension> <a:GroupLevel> <a:RecordSource>EMAIL_LIST</a:RecordSource> <a

efaultSort></a

efaultSort> <a:HeaderElementId>HeaderEMAILLIST</a:HeaderElementId> <a:FooterElementId></a:FooterElementId> <a:CaptionElementId></a:CaptionElementId> <a:RecordNavigationElementId>NavigationSectionEMAILLIST</a:RecordNavigationElementId> <a

ataPageSize>1</a

ataPageSize> </a:GroupLevel> <a

atamodel version="0816"> <a:SchemaRowsource id="CUSTOMER_MASTER" type="dscTable"> <a:SchemaField id="CM_ID" datatype="3" size="0" iskey="1"/> <a:SchemaField id="CM_ST_ID" datatype="3" size="0"/> <a:SchemaField id="CM_TITLE" datatype="130" size="10"/> <a:SchemaField id="CM_NAME_FIRST" datatype="202" size="60"/> <a:SchemaField id="CM_NAME_MIDDLE" datatype="2" size="0"/> <a:SchemaField id="CM_NAME_LAST" datatype="202" size="60"/> <a:SchemaField id="CM_SOCIAL_SECURITY_NUM" datatype="2" size="0"/> <a:SchemaField id="CM_MEDICAL_ID" datatype="2" size="0"/> <a:SchemaField id="CM_DATE_OF_BIRTH" datatype="7" size="0"/> <a:SchemaField id="CM_RACE" datatype="130" size="10"/> <a:SchemaField id="CM_FEMALE_Y" datatype="2" size="0"/> <a:SchemaField id="CM_COMPANY_NAME" datatype="202" size="60"/> <a:SchemaField id="CM_ADDR_LINE1" datatype="202" size="60"/> <a:SchemaField id="CM_ADDR_LINE2" datatype="202" size="60"/> <a:SchemaField id="CM_CITY" datatype="130" size="24"/> <a:SchemaField id="CM_STATE" datatype="130" size="24"/> <a:SchemaField id="CM_ZIP" datatype="130" size="10"/> <a:SchemaField id="CM_WORK_PHONE" datatype="130" size="24"/> <a:SchemaField id="CM_HOME_PHONE" datatype="130" size="24"/> <a:SchemaField id="CM_CELL_PHONE" datatype="130" size="24"/> <a:SchemaField id="CM_FAX" datatype="130" size="24"/> <a:SchemaField id="CM_EMAIL" datatype="202" size="60"/> <a:SchemaField id="CM_METRIC" datatype="130" size="10"/> <a:SchemaField id="CM_SITE_EMP_Y" datatype="130" size="1"/> <a:SchemaField id="CM_INSERT_UID" datatype="130" size="10"/> <a:SchemaField id="CM_INSERT_DATE" datatype="7" size="0"/> <a:SchemaField id="CM_MODIFY_UID" datatype="130" size="10"/> <a:SchemaField id="CM_MODIFY_DATE" datatype="7" size="0"/> <a:SchemaField id="CM_DELETE_UID" datatype="130" size="10"/> <a:SchemaField id="CM_DELETE_DATE" datatype="7" size="0"/> <a:SchemaField id="CM_DELETE_Y" datatype="130" size="10"/> </a:SchemaRowsource> <a:SchemaRowsource id="EMAIL_LIST" type="dscTable"> <a:SchemaField id="EM_ID" datatype="3" size="0" iskey="1"/> <a:SchemaField id="CM_ID" datatype="3" size="0"/> <a:SchemaField id="EM_ADDRESS" datatype="202" size="128"/> <a:SchemaField id="EM_PRIORITY" datatype="130" size="10"/> <a:SchemaField id="EM_TYPE" datatype="130" size="10"/> <a:SchemaField id="EM_INSERT_UID" datatype="130" size="10"/> <a:SchemaField id="EM_INSERT_DATE" datatype="7" size="0"/> <a:SchemaField id="EM_MODIFY_UID" datatype="130" size="10"/> <a:SchemaField id="EM_MODIFY_DATE" datatype="7" size="0"/> <a:SchemaField id="EM_DELETE_UID" datatype="130" size="10"/> <a:SchemaField id="EM_DELETE_DATE" datatype="7" size="0"/> <a:SchemaField id="EM_DELETE_Y" datatype="130" size="10"/> </a:SchemaRowsource> <a:RecordsetDef id="EMAIL_LIST"> <a

ageField id="EM_ID"/> <a

ageField id="CM_ID"/> <a

ageField id="EM_ADDRESS"/> <a

ageField id="EM_PRIORITY"/> <a

ageField id="EM_TYPE"/> <a

ageField id="CM_ID3" source="CM_ID"/> <a

ageField id="CM_ID4" source="CM_ID"/> <a

ageField id="CM_ID5" source="CM_ID"/> <a

ageRowsource id="CUSTOMER_MASTER" lookupsource="EMAIL_LIST" relationship="CUSTOMER_MASTER_EMAIL_LIST_FK1"> <a

ageField id="CM_ID1" source="CM_ID"/> <a

ageField id="CM_NAME_FIRST"/> <a

ageField id="CM_NAME_LAST"/> <a:RelatedField primary="CM_ID1" foreign="CM_ID"/> </a

ageRowsource> </a:RecordsetDef> </a

atamodel> </a

ataSourceControl> </xml>'""></OBJECT>
<META content="MSHTML 5.00.2920.0" name=GENERATOR>
<META content="sandston 011" name="Microsoft Theme 2.00"><LINK
href="./email%20list1_files/file0002.css" id=mstheme rel=StyleSheet
type=text/css><LINK href="./email%20list1_files/file0003.css" id=mstheme
rel=StyleSheet type=text/css><LINK href="./email%20list1_files/file0007.css"
id=mstheme rel=StyleSheet type=text/css><!--[if gte mso 9]><xml>
<o

ocumentProperties>
<o:Author>toms</o:Author>
<o:LastAuthor>toms</o:LastAuthor>
<o:Revision>1</o:Revision>
<o:TotalTime>0</o:TotalTime>
<o:Created>2001-04-16T20:53:45Z</o:Created>
<o:LastSaved>2001-04-16T21:28:05Z</o:LastSaved>
<o:Company>Cardiobeat</o:Company>
<o:Version>9.3821</o:Version>
</o

ocumentProperties>
<o:OfficeDocumentSettings>
<o

ownloadComponents/>
<o:LocationOfComponents HRef="file:msowc.cab"/>
</o:OfficeDocumentSettings>
</xml><![endif]--></HEAD>
<BODY bottomMargin=48 leftMargin=24 link=#800080 rightMargin=24
style="OVERFLOW: auto" topMargin=24 vLink=#800080>
<CENTER>
<H1 id=HeadingText style="FONT-WEIGHT: normal">Email Distribution
List </H1></CENTER>
<P> </P>
<DIV class=MicrosoftAccessBanner id=HeaderEMAILLISTBanner
style="BACKGROUND-COLOR: buttonface; BORDER-BOTTOM: buttonhighlight 2px outset; BORDER-LEFT: buttonhighlight 2px outset; BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt; FONT-WEIGHT: normal; HEIGHT: 0.2in; OVERFLOW: hidden; PADDING-LEFT: 1px; WIDTH: 563px">Header:
EMAIL_LIST</DIV>
<DIV class=MSOShowDesignGrid id=HeaderEMAILLIST
style="BACKGROUND-COLOR: transparent; HEIGHT: 122px; OVERFLOW: hidden; POSITION: relative; VISIBILITY: hidden; WIDTH: 563px"><SPAN
class=MSTheme-Label id=EM_ID_Label
style="HEIGHT: 0.188in; LEFT: 0.042in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.042in; WIDTH: 1.083in"
title=EM_ID>EM_ID</SPAN><TEXTAREA id=EM_ID style="HEIGHT: 0.188in; LEFT: 1.125in; OVERFLOW: hidden; POSITION: absolute; TOP: 0.042in; WIDTH: 1.604in" tabIndex=1 title=EM_ID></TEXTAREA><SPAN
class=MSTheme-Label id=CM_ID_Label
style="HEIGHT: 0.188in; LEFT: 0.042in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.292in; WIDTH: 1.083in"
title=CM_ID>CM_ID</SPAN><TEXTAREA id=CM_ID style="HEIGHT: 0.188in; LEFT: 1.125in; OVERFLOW: hidden; POSITION: absolute; TOP: 0.292in; WIDTH: 0.823in" tabIndex=2 title=CM_ID></TEXTAREA><SPAN
class=MSTheme-Label id=EM_ADDRESS_Label
style="HEIGHT: 0.188in; LEFT: 0.042in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.542in; WIDTH: 1.083in"
title=EM_ADDRESS>EM_ADDRESS</SPAN><TEXTAREA id=EM_ADDRESS style="HEIGHT: 0.188in; LEFT: 1.125in; OVERFLOW: hidden; POSITION: absolute; TOP: 0.542in; WIDTH: 3.167in" tabIndex=3 title=EM_ADDRESS></TEXTAREA><SPAN
class=MSTheme-Label id=EM_PRIORITY_Label
style="HEIGHT: 0.188in; LEFT: 0.042in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.792in; WIDTH: 1.083in"
title=EM_PRIORITY>EM_PRIORITY</SPAN><TEXTAREA id=EM_PRIORITY style="HEIGHT: 0.188in; LEFT: 1.125in; OVERFLOW: hidden; POSITION: absolute; TOP: 0.792in; WIDTH: 0.823in" tabIndex=4 title=EM_PRIORITY></TEXTAREA><SPAN
class=MSTheme-Label id=EM_TYPE_Label
style="HEIGHT: 0.188in; LEFT: 0.042in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 1.042in; WIDTH: 1.083in"
title=EM_TYPE>EM_TYPE</SPAN><TEXTAREA id=EM_TYPE style="HEIGHT: 0.188in; LEFT: 1.125in; OVERFLOW: hidden; POSITION: absolute; TOP: 1.042in; WIDTH: 0.823in" tabIndex=5 title=EM_TYPE></TEXTAREA><SPAN
class=MSTheme-Label id=CM_NAME_FIRST_Label
style="HEIGHT: 0.166in; LEFT: 3.25in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.083in; WIDTH: 1in"
title=CM_NAME_FIRST>CM_NAME_FIRST</SPAN><TEXTAREA id=CM_NAME_FIRST style="HEIGHT: 0.187in; LEFT: 4.25in; OVERFLOW: hidden; POSITION: absolute; TOP: 0.083in; WIDTH: 1in" tabIndex=6 title=CM_NAME_FIRST></TEXTAREA><SPAN
class=MSTheme-Label id=CM_NAME_LAST_Label
style="HEIGHT: 0.166in; LEFT: 3.25in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.333in; WIDTH: 1in"
title=CM_NAME_LAST>CM_NAME_LAST</SPAN><TEXTAREA id=CM_NAME_LAST style="HEIGHT: 0.187in; LEFT: 4.25in; OVERFLOW: hidden; POSITION: absolute; TOP: 0.333in; WIDTH: 1in" tabIndex=7 title=CM_NAME_LAST></TEXTAREA><SPAN
class=MSTheme-Label id=DropdownList0_Label
style="HEIGHT: 0.166in; LEFT: 2.083in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.875in; WIDTH: 1in"
title=CM_ID>CM_ID</SPAN><SELECT id=DropdownList0
style="HEIGHT: 0.187in; LEFT: 3.083in; POSITION: absolute; TOP: 0.875in; WIDTH: 1in"
tabIndex=8 title=DropdownList0></SELECT></DIV>
<DIV class=MicrosoftAccessBanner id=NavigationSectionEMAILLISTBanner
style="BACKGROUND-COLOR: buttonface; BORDER-BOTTOM: buttonhighlight 2px outset; BORDER-LEFT: buttonhighlight 2px outset; BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; FONT-FAMILY: Tahoma; FONT-SIZE: 8pt; FONT-WEIGHT: normal; HEIGHT: 0.2in; OVERFLOW: hidden; PADDING-LEFT: 1px; WIDTH: 563px">NavigationSection:
EMAIL_LIST</DIV>
<DIV class=MSOShowDesignGrid id=NavigationSectionEMAILLIST
style="BACKGROUND-COLOR: transparent; HEIGHT: 35px; OVERFLOW: hidden; POSITION: relative; VISIBILITY: hidden; WIDTH: 563px">
<OBJECT classid=CLSID:0002E531-0000-0000-C000-000000000046
codeBase=file:msowc.cab id=EMAIL_LISTNavigation
style="LEFT: 8px; POSITION: absolute; TOP: 5px; WIDTH: 462px"><PARAM NAME="_State" VALUE=""><PARAM NAME="RecordSource" VALUE="EMAIL_LIST"><PARAM NAME="RecordsetLabel" VALUE="EMAIL_LIST |0 of |2;EMAIL_LIST |0-|1 of |2"><PARAM NAME="ShowFirstButton" VALUE="-1"><PARAM NAME="ShowPrevButton" VALUE="-1"><PARAM NAME="ShowNextButton" VALUE="-1"><PARAM NAME="ShowLastButton" VALUE="-1"><PARAM NAME="ShowNewButton" VALUE="-1"><PARAM NAME="ShowDelButton" VALUE="-1"><PARAM NAME="ShowSaveButton" VALUE="-1"><PARAM NAME="ShowUndoButton" VALUE="-1"><PARAM NAME="ShowSortAscendingButton" VALUE="-1"><PARAM NAME="ShowSortDecendingButton" VALUE="-1"><PARAM NAME="ShowApplyFilterButton" VALUE="-1"><PARAM NAME="ShowToggleFilterButton" VALUE="-1"><PARAM NAME="ShowHelpButton" VALUE="-1"><PARAM NAME="ShowLabel" VALUE="-1"><PARAM NAME="FontName" VALUE="Tahoma"></OBJECT></DIV>
<P> </P></BODY></HTML>