https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17062.aspxWed, 09 Nov 2005 06:44:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17062franck0https://www.infopathdev.com:443/forums/thread/17062.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17062sorry, I missed your answer there.... <br />You can do a search for "Secondary DOM" in this forum to get some samples.<br /><br />Franckhttps://www.infopathdev.com:443/forums/thread/17061.aspxWed, 02 Nov 2005 02:10:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17061jrothstein0https://www.infopathdev.com:443/forums/thread/17061.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17061Hi,<br /><br />Thanks for the quick reply. What you describe is exactly how my form is setup. Unfortunately, I am at best a novice programmer so really have no idea how I would code this. Could you point me to any MSDN articles that would deal with a scenario like this, or any code snippets I may adopt for this purpose?<br /><br />Much Appreciated,<br /><br />Jasonhttps://www.infopathdev.com:443/forums/thread/17060.aspxWed, 02 Nov 2005 01:22:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17060franck0https://www.infopathdev.com:443/forums/thread/17060.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17060Hi,<br /><br />The address is stored in your primary DOM, right? So, even if the secondary data source did change, the changes won't automatically flow to your main DOM. You need to open your secondary DOM by code and compare data for a given Customer ID. You can do this OnLoad and/or with a Refresh button. It will involve some coding, but it is doable.<br /><br />Regards,<br /><br />Franck Dauchéhttps://www.infopathdev.com:443/forums/thread/16752.aspxTue, 01 Nov 2005 22:33:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16752jrothstein0https://www.infopathdev.com:443/forums/thread/16752.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16752Hello,<br /><br />I have a form that has a drop-down list box attached to an SQL server secondary data source that contains customer names and addresses. When a user chooses the customer name from the drop-down list, the address, zip, etc fields auto-fills using the rules method. However, if the customer's address changes in the data source and we re-open the form, the address and other info still displays the old data. The only way to get it to update in the form is to change the drop down list to a different customer, and then change it back. I tried adding a "Refresh" button that is set to refresh all data sources, but it doesn't seem to refresh the data. Can anybody suggest a method for either getting this "refresh" button to work as I think it should, or to set the form to refresh the data each time it is opened?<br /><br />Thanks,<br /><br />Jason