https://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)https://www.infopathdev.com:443/forums/thread/71774.aspxFri, 04 Nov 2011 20:02:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:71774Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/71774.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=71774<p>Well - InfoPath can submit to SQL - but I&#39;m not sure if it is going to let you combine two databases for its data source.</p> <p>As to several ways to see the results - I guess you could lay the data fields out differently in different sections, and give the user an option button or something and use conditional formatting to determine which section to display.</p> <p>Query fields are pretty straight-forward on a database bound field - it is just used for equivalency - so field = value</p> <p>I like the Office Online InfoPath Help for the basics - Here&#39;s a <a href="http://office.microsoft.com/en-us/infopath-help/?CTT=97">link</a> to get you started.</p>https://www.infopathdev.com:443/forums/thread/71724.aspxThu, 03 Nov 2011 16:38:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:71724lstieg0https://www.infopathdev.com:443/forums/thread/71724.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=71724<p>VERY NEW to this... opened the program for the first time a week or so ago.... </p> <p>&nbsp;Long story short....</p> <p>&nbsp;I have been tasked with coming up with a resolution to the issue of constantly changing schedule information in our reporting system.</p> <p>&nbsp;I have 2 sql db&#39;s</p> <p>DB1 emailaddr, recipientname, facilityname, clientclass, deactivatedt, createdt, rptnum, emailcode</p> <p>DB2 emailaddr, frequency, format, facilityname, clientclass, deactivatedt, createdt, rptnum, emailcode</p> <p>&nbsp;What I want is a form that a user can go to and </p> <p>&nbsp;&nbsp;a. add new information</p> <p>&nbsp; b. deactivate an acct - simply by putting in a deactivate dt....</p> <p>&nbsp; c. pull up a list of all schedules based on clientclass &amp;/or clientclass/rptnum</p> <p>Created a form but having a few issues... so I have the &nbsp;New Record Section with the fields they need to fill out however would like to have a button/checkbox something that first says they want to enter new or deactivate.... then based on selection certain fields show up</p> <p>In the run query section trying to understand some things... </p> <p>There are several ways they may want to see results from a simple summary to all details... can this be accomplished or no?</p> <p>Can anyone point me in the direction of some good training material/samples?</p> <p>Thanks in advance for any help/advice.</p> <p>&nbsp;</p> <p>&nbsp;</p>