https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/40616.aspxWed, 15 Apr 2009 00:48:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:40616Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/40616.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=40616<p>I&#39;d create a view in the SQL db that combines the two tables and use that as my data source for the drop down list. As you&#39;ve noticed, you can only select one data source for a drop down&#39;s value / display pairs in IP, so a view or code will be the only way to do this....</p>https://www.infopathdev.com:443/forums/thread/40528.aspxSat, 11 Apr 2009 21:45:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:40528lukeksmith0https://www.infopathdev.com:443/forums/thread/40528.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=40528<p>Im using an SQL db.&nbsp; I made a data connection with two tables.&nbsp; I have a table with&nbsp;some fields: A_ContractID, A_ContractDate and A_CustomerID_Key.&nbsp; Then I added another table with B_ContractID_Key. I also made a second data connection so I can populate dropdown list entries when the form loads.</p> <p>I want to&nbsp;design&nbsp;a form using the second table&#39;s datafields.&nbsp; I want to create a dropdown listbox for B_ContractID_Key which is populated from a external datasource.&nbsp; I want the value to be B_ContractID_Key and the Display Name to be &quot;A_CustomerID_Key - A_ContractDate&quot;.&nbsp; So I can select a ContractID based on two other fields.&nbsp; How can I do this?</p>