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/3826.aspxThu, 18 Jan 2007 06:45:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3826lyntonS0https://www.infopathdev.com:443/forums/thread/3826.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3826Thanks - I have also discovered that if I create individual look-up tables in Sql Express to hold the values; calling them from within InfoPath by:<br /><br />1.) Right-clicking the drop-down list and selecting drop-down list properties.<br />2.) I then can navigate through a connection wizard when I select 'Look-up values from an external data source'.<br /><br />Once I have done this the fields can be submitted and queried no problems! <br /><br />I hope that this will help anyone in search of clues.https://www.infopathdev.com:443/forums/thread/3825.aspxThu, 11 Jan 2007 18:06:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3825Matt Faus0https://www.infopathdev.com:443/forums/thread/3825.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3825Hi Lynton and welcome to the forums!<br /><br />This sounds like a weird bug - my only suggestion would be to check the authentication settings, sometimes InfoPath has a hard time with this. Make sure that the site is added to your Local Intranet sites.https://www.infopathdev.com:443/forums/thread/1790.aspxThu, 11 Jan 2007 07:49:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1790lyntonS0https://www.infopathdev.com:443/forums/thread/1790.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1790I have included a number of DDL's and have added their values using the InfoPath properties windows. Submitting of the completed form is successful and the complete record appears. The problem is that when I submit the query to retrieve the record using the 'empCode' which I created the stored values are not being displayed - only the default 'Select...' field is showing. I have checked the Sql connections and the Web Service for possible errors. Am I missing something?