<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Newbie Questions</title><link>https://www.infopathdev.com:443/forums/39.aspx</link><description>New 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.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Filling a drop down list</title><link>https://www.infopathdev.com:443/forums/thread/85860.aspx</link><pubDate>Tue, 08 Jan 2013 15:49:42 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:85860</guid><dc:creator>Hilary Stoupa</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/85860.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&amp;PostID=85860</wfw:commentRss><description>I&amp;#39;m sorry - I&amp;#39;ve read this and am having trouble understanding - my guess is that you want to combine two data sources for your drop down values - are both data sources in SQL? If so, use a view to combine them into one.</description></item><item><title>Filling a drop down list</title><link>https://www.infopathdev.com:443/forums/thread/85745.aspx</link><pubDate>Thu, 03 Jan 2013 12:45:34 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:85745</guid><dc:creator>learninginfopath</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/85745.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&amp;PostID=85745</wfw:commentRss><description>&lt;p&gt;I have a dropdown list connected with secondary data source (external SQL Server database through webservice).Secondary data source contains attribute field: - User ID (Ex:1,2,3,4)&lt;/p&gt;
&lt;p&gt;Ex: For User Id : 1 the selected value from DB is &amp;quot;A&amp;quot;&lt;/p&gt;
&lt;table style="BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;BORDER-COLLAPSE:collapse;BORDER-TOP:medium none;BORDER-RIGHT:medium none;mso-border-alt:solid windowtext .5pt;mso-yfti-tbllook:1184;mso-padding-alt:0in 5.4pt 0in 5.4pt;" class="MsoTableGrid" cellspacing="0" cellpadding="0"&gt;

&lt;tr style="HEIGHT:10.35pt;mso-yfti-irow:0;mso-yfti-firstrow:yes;"&gt;
&lt;td style="BORDER-BOTTOM:windowtext 1pt solid;BORDER-LEFT:windowtext 1pt solid;PADDING-BOTTOM:0in;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:43.7pt;PADDING-RIGHT:5.4pt;HEIGHT:10.35pt;BORDER-TOP:windowtext 1pt solid;BORDER-RIGHT:windowtext 1pt solid;PADDING-TOP:0in;mso-border-alt:solid windowtext .5pt;"&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoNormal"&gt;&lt;span style="FONT-SIZE:8pt;mso-bidi-font-size:12.0pt;"&gt;&lt;font face="Times New Roman"&gt;UserID&lt;/font&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="BORDER-BOTTOM:windowtext 1pt solid;BORDER-LEFT:#d4d0c8;PADDING-BOTTOM:0in;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:43.7pt;PADDING-RIGHT:5.4pt;HEIGHT:10.35pt;BORDER-TOP:windowtext 1pt solid;BORDER-RIGHT:windowtext 1pt solid;PADDING-TOP:0in;mso-border-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;"&gt;&lt;span style="FONT-SIZE:8pt;mso-bidi-font-size:12.0pt;"&gt;&lt;font face="Times New Roman"&gt;Name&lt;/font&gt;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="HEIGHT:10.35pt;mso-yfti-irow:1;"&gt;
&lt;td style="BORDER-BOTTOM:windowtext 1pt solid;BORDER-LEFT:windowtext 1pt solid;PADDING-BOTTOM:0in;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:43.7pt;PADDING-RIGHT:5.4pt;HEIGHT:10.35pt;BORDER-TOP:#d4d0c8;BORDER-RIGHT:windowtext 1pt solid;PADDING-TOP:0in;mso-border-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt;"&gt;&lt;span style="FONT-SIZE:8pt;mso-bidi-font-size:12.0pt;"&gt;&lt;font face="Times New Roman"&gt;1&lt;/font&gt;&lt;/span&gt;&lt;/td&gt;
&lt;td style="BORDER-BOTTOM:windowtext 1pt solid;BORDER-LEFT:#d4d0c8;PADDING-BOTTOM:0in;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:43.7pt;PADDING-RIGHT:5.4pt;HEIGHT:10.35pt;BORDER-TOP:#d4d0c8;BORDER-RIGHT:windowtext 1pt solid;PADDING-TOP:0in;mso-border-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt;"&gt;&lt;span style="FONT-SIZE:8pt;mso-bidi-font-size:12.0pt;"&gt;&lt;font face="Times New Roman"&gt;A&lt;/font&gt;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="HEIGHT:10.35pt;mso-yfti-irow:2;"&gt;
&lt;td style="BORDER-BOTTOM:windowtext 1pt solid;BORDER-LEFT:windowtext 1pt solid;PADDING-BOTTOM:0in;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:43.7pt;PADDING-RIGHT:5.4pt;HEIGHT:10.35pt;BORDER-TOP:#d4d0c8;BORDER-RIGHT:windowtext 1pt solid;PADDING-TOP:0in;mso-border-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt;"&gt;&lt;span style="FONT-SIZE:8pt;mso-bidi-font-size:12.0pt;"&gt;&lt;font face="Times New Roman"&gt;2&lt;/font&gt;&lt;/span&gt;&lt;/td&gt;
&lt;td style="BORDER-BOTTOM:windowtext 1pt solid;BORDER-LEFT:#d4d0c8;PADDING-BOTTOM:0in;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:43.7pt;PADDING-RIGHT:5.4pt;HEIGHT:10.35pt;BORDER-TOP:#d4d0c8;BORDER-RIGHT:windowtext 1pt solid;PADDING-TOP:0in;mso-border-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt;"&gt;&lt;span style="FONT-SIZE:8pt;mso-bidi-font-size:12.0pt;"&gt;&lt;font face="Times New Roman"&gt;B&lt;/font&gt;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="HEIGHT:10.7pt;mso-yfti-irow:3;"&gt;
&lt;td style="BORDER-BOTTOM:windowtext 1pt solid;BORDER-LEFT:windowtext 1pt solid;PADDING-BOTTOM:0in;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:43.7pt;PADDING-RIGHT:5.4pt;HEIGHT:10.7pt;BORDER-TOP:#d4d0c8;BORDER-RIGHT:windowtext 1pt solid;PADDING-TOP:0in;mso-border-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt;"&gt;&lt;span style="FONT-SIZE:8pt;mso-bidi-font-size:12.0pt;"&gt;&lt;font face="Times New Roman"&gt;3&lt;/font&gt;&lt;/span&gt;&lt;/td&gt;
&lt;td style="BORDER-BOTTOM:windowtext 1pt solid;BORDER-LEFT:#d4d0c8;PADDING-BOTTOM:0in;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:43.7pt;PADDING-RIGHT:5.4pt;HEIGHT:10.7pt;BORDER-TOP:#d4d0c8;BORDER-RIGHT:windowtext 1pt solid;PADDING-TOP:0in;mso-border-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt;"&gt;&lt;span style="FONT-SIZE:8pt;mso-bidi-font-size:12.0pt;"&gt;&lt;font face="Times New Roman"&gt;C&lt;/font&gt;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="HEIGHT:10.7pt;mso-yfti-irow:4;mso-yfti-lastrow:yes;"&gt;
&lt;td style="BORDER-BOTTOM:windowtext 1pt solid;BORDER-LEFT:windowtext 1pt solid;PADDING-BOTTOM:0in;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:43.7pt;PADDING-RIGHT:5.4pt;HEIGHT:10.7pt;BORDER-TOP:#d4d0c8;BORDER-RIGHT:windowtext 1pt solid;PADDING-TOP:0in;mso-border-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt;"&gt;&lt;span style="FONT-SIZE:8pt;mso-bidi-font-size:12.0pt;"&gt;&lt;font face="Times New Roman"&gt;4&lt;/font&gt;&lt;/span&gt;&lt;/td&gt;
&lt;td style="BORDER-BOTTOM:windowtext 1pt solid;BORDER-LEFT:#d4d0c8;PADDING-BOTTOM:0in;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:43.7pt;PADDING-RIGHT:5.4pt;HEIGHT:10.7pt;BORDER-TOP:#d4d0c8;BORDER-RIGHT:windowtext 1pt solid;PADDING-TOP:0in;mso-border-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt;"&gt;&lt;span style="FONT-SIZE:8pt;mso-bidi-font-size:12.0pt;"&gt;&lt;font face="Times New Roman"&gt;D&lt;/font&gt;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
&lt;p&gt;I will select the User ID dropdown&amp;nbsp;and on click of button, another dropdown will be loaded with corresponding record from DB( external SQL Server database : through webservice)&lt;/p&gt;
&lt;p&gt;However here along with the value from DB(i.e. along with A) I&amp;nbsp;want to show other options(B,C,D from one more secondary data source through webservice)&amp;nbsp;also in the dropdown(for user to make/change selection) and have the DB value selected in the dropdown &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item></channel></rss>