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/120819.aspxFri, 12 Apr 2019 16:05:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120819Anubhav0https://www.infopathdev.com:443/forums/thread/120819.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=120819Thanks Hilary. You know what I was looking for some kind of mechanism t print values and able to debug a sort of. This will really help me with it. Anubhavhttps://www.infopathdev.com:443/forums/thread/120818.aspxFri, 12 Apr 2019 15:23:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120818Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120818.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=120818Hey, great job figuring it out - the learning curve at the beginning can seem a bit steep. One thing that helped me a lot was just dragging my various data sources onto the form, making sure all the data was displayed in text controls so I could see the actual values of stuff - especially when working with secondary data sources. It is easy to delete stuff when you are done designing, and actually seeing the data helped me a lot - Oh, and I would add buttons to execute queries, and put the query fields on the form as well, so I could see what worked & what didn't.https://www.infopathdev.com:443/forums/thread/120816.aspxFri, 12 Apr 2019 15:05:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120816Anubhav0https://www.infopathdev.com:443/forums/thread/120816.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=120816Hi Hilary, I stopped with my development of Blank and went ahead with Database Form. I was able to achieve my objectives by performing following actions. 1) Populate the drop down - added a rule on "On load event" and then in that rule i added a second action of setting the value from data field - SUCCESS!! 2) I was comparing with text and not value field so compared and got he result. SUCCESS. Thanks for the reply. Will post more questions as I proceed. Regards, Anubhavhttps://www.infopathdev.com:443/forums/thread/120814.aspxFri, 12 Apr 2019 14:46:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120814Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120814.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=120814It would help me if I could see a copy of your form (the one where you started from a blank form) - you can attach it under Options in a reply. As to why your blank form doesn't have query fields in the main data source - those are only there with data bound forms. For a form where you start from blank, there is nothing in the main data source to query - the XML is all just data.https://www.infopathdev.com:443/forums/thread/120810.aspxFri, 12 Apr 2019 03:04:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120810Anubhav0https://www.infopathdev.com:443/forums/thread/120810.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=120810Hi Experts!! I have just started with InfoPath Development. So I was designing forms based on SQL DB as the backend. So there are just 2 fields in this form: 1 Drop down (which I want to autopopulate on loading of Form) & Text field ( which I want to fill based on the selection of dropdown value). 1) I have not designed this as Database Form as I was not able to populate the dropdown ( Basically i could not find the checkbox of "Autopopulate on load" in wizard) 2) Then I have designed this as a Blank form in which I was able to auto populate the drop down values. Now comes to filling of Text field, so I have adopted this approach: a) On this drop down created a Rule 1 to query the SQL Table. b) Then created Rule 2 - "Set the field value" in Field as "datafield" of Table (text field) and Value as same data field (of SECONDARY CONNECTION) with filter ( dropdown value as equal to dropdown-like field in "datafield"). Issue: Now my dropdown is filled only first time and is NULL on change of dropdown value. So I am not able to ppulate my Text field. Also i have a curiosity that why these Blank Forms does not have queryfields and only DataFields? Any help will be much appreciated.