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/16891.aspxFri, 10 Sep 2004 20:22:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16891Greg Collins0https://www.infopathdev.com:443/forums/thread/16891.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16891Glad to hear you got it fixed! Thanx for the update.<br /><br />Greg Collins [InfoPath MVP]https://www.infopathdev.com:443/forums/thread/16890.aspxWed, 08 Sep 2004 17:07:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16890oakridge0https://www.infopathdev.com:443/forums/thread/16890.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16890I have found the error. I was doing a comparison on a parent table above the table I was querying. The data I had entered into the child table did not have corresponding data in the parent table.<br /><br />Thanks for your help.https://www.infopathdev.com:443/forums/thread/16889.aspxTue, 07 Sep 2004 11:30:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16889oakridge0https://www.infopathdev.com:443/forums/thread/16889.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16889Thanks for the reply. On Friday, I checked the database and the data records were there. Today I set up a new form and it retrieved the data.https://www.infopathdev.com:443/forums/thread/16888.aspxSat, 04 Sep 2004 20:47:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16888Greg Collins0https://www.infopathdev.com:443/forums/thread/16888.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16888Try two things and then get back to me...<br /><br />1. Go into the Enterprise Manager and verify that the SQL content has been updated in the database.<br /><br />2. Create a new form which attaches to the database and see if you can get the new form to bring down the updated rows.<br /><br />Greg Collins [InfoPath MVP]https://www.infopathdev.com:443/forums/thread/16696.aspxFri, 03 Sep 2004 20:21:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16696oakridge0https://www.infopathdev.com:443/forums/thread/16696.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16696I have drop down lists associated with a SQL database. That database is updated through another form. I then open the form that has the dropdowns in it. The data is not being retrieved. I check the parameters for the secondary database and the option to automatically retrieve the data on open is checked.<br /><br />What could be causing this issue?<br /><br />