https://www.infopathdev.com:443/forums/41.aspxIf 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.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/7115.aspxWed, 13 Jul 2005 09:03:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7115Patrick Halstead0https://www.infopathdev.com:443/forums/thread/7115.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7115Hi again,<br />Well, InfoPath has great offline support. If yor database connections happen OnLoad, then it should just work so long as the form was opened when they were connected. If they need to have data prepopulated to the dropdowns when they are disconnected, then you'll have to provide a secondary data source (add a XML file data connection) that includes the default data. You can then write code in your OnLoad to check connectivity and either fill in from DB or secondary data source.<br /><br />Patrick Halstead [InfoPath MVP]<br />InfoPathDevhttps://www.infopathdev.com:443/forums/thread/7114.aspxTue, 12 Jul 2005 05:29:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7114jobe0https://www.infopathdev.com:443/forums/thread/7114.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7114I don't have it working offline. That's my challenge at the moment. Can you explain the easiest way to do it? The user needs to be able to fill out the form while disconnected (1 or many forms) and then once re-connected, have them submit automatically.<br /><br />How do I cache locally in the main DOM until people are ready to submit?<br /><br />Thanks for your help Patrick!<br /><br />Jo<br />https://www.infopathdev.com:443/forums/thread/7113.aspxFri, 08 Jul 2005 06:02:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7113Patrick Halstead0https://www.infopathdev.com:443/forums/thread/7113.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7113Hi Jo,<br />This is difficult to do without writing code because of the limits of the data connection wizard. The Database Adapter that we sell (and provide free for download) is an example of a Web service that supports multiple tables and requires no code in the form.<br /><br />I think the main benefit of the Web service is the abstraction that it provides. But, hey, if your form is working, why worry!? <br /><br />For offline, I imagine that you already have it working, but consider caching locally in the main DOM until people are ready to submit.<br /><br />Good luck!<br /><br />Patrick Halstead [InfoPath MVP]<br />InfoPathDevhttps://www.infopathdev.com:443/forums/thread/4762.aspxFri, 08 Jul 2005 04:05:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4762jobe0https://www.infopathdev.com:443/forums/thread/4762.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4762I have an infopath form that will be integrating with sql server and Sharepoint. I need to base my main data connection on two tables which means when I add or modify records, it needs to be done to the two tables. I have it working at the moment just using a database connection.<br /><br />When do I need to use a web service? <br /><br />Most documentation I have read talks about using a web service for what I am doing, but I can't find any examples of how to set up a web service send and receive with 2 tables. All examples use 1 table.<br /><br />I am a little worried that I have based everything on a database connection instead of a web service. Is this a problem?<br /><br />The form needs to work offline with offline submitting an option. <br /><br />Thanks in advance for your knowledge!<br /><br />Jo