<?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>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Main vs Secondary Connection (SQL Server Database)</title><link>https://www.infopathdev.com:443/forums/thread/108367.aspx</link><pubDate>Thu, 27 Oct 2016 23:07:04 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:108367</guid><dc:creator>Hilary Stoupa</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/108367.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=108367</wfw:commentRss><description>&lt;p&gt;&amp;nbsp;If you want to submit to SQL without code / web services, you do have to create the form off the database. Can you attach a screenshot or a copy of your template? I&amp;#39;m having a hard time visualizing the issue. You can attach a file under the options tab in a reply. :)&lt;/p&gt;</description></item><item><title>Main vs Secondary Connection (SQL Server Database)</title><link>https://www.infopathdev.com:443/forums/thread/108329.aspx</link><pubDate>Tue, 25 Oct 2016 19:47:19 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:108329</guid><dc:creator>abdool3002</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/108329.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=108329</wfw:commentRss><description>Hi,

I&amp;#39;m hoping someone can offer some advice to help solve my problem. I&amp;#39;m working on creating a form that has two sections, a feedback section and a section below  which displays pertinent information. The feedback section has three fields which the user will provide input. One is a date and the other is &amp;quot;Submitted&amp;quot;/&amp;quot;Not Submitted&amp;quot; option. The third field is the Project Number which is a drop down option that I want to be used to query. 

 Below this section will display information such as Project Name, Budget etc. I&amp;#39;ve created a view in sql server which provides all the information for the lower part of the form and I&amp;#39;ve created a table which can be linked to my view (via a unique ID) that will store the responses from the section above. My dilemma is setting up the form&amp;#39;s connection correctly. The only way I could get infopath to allow me to &amp;quot;Submit&amp;quot; the data back to my table was to make the table my main connection. However I&amp;#39;m having trouble setting up the lower part of the form. 

My goal is to have the users pick a project number from the drop down list, hit query, and it will bring back all the information from the view. Once the information is returned, I want them to be able to choose &amp;quot;Submitted/Not Submitted&amp;quot; and the date. Then submit their response back to the database. I&amp;#39;m sorry for the long explanation. I&amp;#39;m hoping someone can provide some advice. Thank you so much in advance.</description></item></channel></rss>