Newbie Questionshttps://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)Re: Use secondary data source as drop_down list box description, but not submit to main data sourcehttps://www.infopathdev.com:443/forums/thread/50035.aspxFri, 18 Dec 2009 04:37:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:50035Jimmy0https://www.infopathdev.com:443/forums/thread/50035.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=50035<p>&nbsp;Please have a look at this thread:</p><p><a href="http://www.infopathdev.com/forums/p/12113/49879.aspx#49879">http://www.infopathdev.com/forums/p/12113/49879.aspx#49879</a> <br /></p>Use secondary data source as drop_down list box description, but not submit to main data sourcehttps://www.infopathdev.com:443/forums/thread/50032.aspxFri, 18 Dec 2009 03:41:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:50032GregAppelt0https://www.infopathdev.com:443/forums/thread/50032.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=50032&nbsp;I&#39;ve done alot of searching, but I can&#39;t seem to find an explanation to a simple issue.&nbsp; Here&#39;s my scenario:<p>SQL 2008 Database with the following tables:<br /> Table &#39;EMPL&#39;:&nbsp; &nbsp; Column 1 &#39;EMPL_ID&#39; int PK, Column2 &#39;EMPL_NAME&#39; varchar(20)<br /> Table &#39;EMPL_DED&#39;:&nbsp;&nbsp;&nbsp; Column 1 &#39;EMPL_DED_INDEX&#39; int PK, Column 2 &#39;EMPL_ID&#39; int, Column 3 &#39;DED_CD&#39; int<br /> Table &#39;DED_DESC&#39;:&nbsp;&nbsp;&nbsp; Column 1 &#39;DED_CD&#39; int PK, Column 2 &#39;DED_DESC&#39; varchar(20)</p><p>explanation of field names: EMPL = Employee, EMPL_ID = Employee_ID, EMPL_DED = Employee Deductions, DED_CD = Deduction Code, DED_DESC = Deduction Description<br /> Relationships:&nbsp; EMPL.EMPL_ID = EMPL_DED.EMPL_ID&nbsp;&nbsp; and EMPL_DED.DED_CD = DED_DESC.DED_CD</p><p>&nbsp;Infopath Data Source (Main) type:Submit &nbsp; Default table: EMPL with table EMPL_DED linked based on EMPL_ID<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Secondary Data Source type: Receive&nbsp;&nbsp;&nbsp; Table: DED_DESC<br /> </p><p>&nbsp;Infopath Form:<br /> Query Section: TextBox &#39;EMPL_ID&#39; Datasource(Main).Binding(MyFields&nbsp;&nbsp; .q:EMPL&nbsp;&nbsp; .EMPL_ID<br /> Record Section: &#39;Repeating Section&#39; Datasource(Main).Binding(MyFields&nbsp;&nbsp; .d:EMPL&nbsp;&nbsp; .EMPL_ID,&nbsp;&nbsp; .EMPL_NAME<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; within Repeating Section &#39;Repeating Table&#39;&nbsp;&nbsp; TextBox EMPL_DED&nbsp; Datasource(Main).Binding(MyFields&nbsp;&nbsp; .d:EMPL(Group:Repeating)&nbsp; .EMPL_DED(Group:Repeating)&nbsp; .DED_CD</p><p>When I run this form it works 100%.&nbsp; When I query an employee&#39;s ID, I get back the Employee ID, Employee Name, and in a repeating table, a list of all of the Deduction Codes that the employee has a record for in the EMPL_DED table.&nbsp; </p><p>My problem is that I would like to include the DED_DESC field next to each of the DED_CD fields in the repeating table.&nbsp; Not to be used as submission data, but simply to present an understandable description to the deduction code.&nbsp; I&#39;ve gotten it to work 1 time, but I don&#39;t remember how.&nbsp; But then I broke it when I tried to figure out how to add a new entry to the repeating table, or even to set the DED_CD field as a&nbsp; drop-down list that displayed both the DED_CD and DED_DESC.</p>I&#39;d be happy to send you my simple SQL database and current form if that would help at all.