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/25123.aspxFri, 14 Dec 2007 07:59:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:25123adamrharding0https://www.infopathdev.com:443/forums/thread/25123.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=25123<p>Hi</p> <p>I think this will help.&nbsp; </p> <p>Double-click the field to get into its properties.&nbsp; Then click the fx button on the end of the default value row.&nbsp; Select &#39;Insert Field or Group&#39; and browse to your table and the field you want.&nbsp; </p> <p>At this point there is an option to filter the data by a formula or a value on the form, for example, I type in my employee number and the <strong>NAME </strong>field is populated from the database filtering the options to show the name where the employee number matches the number i typed in.</p> <p>Either way when you have set things up to your satisfaction OK out of there and test.</p> <p>Should work a treat?</p>https://www.infopathdev.com:443/forums/thread/24796.aspxThu, 29 Nov 2007 16:45:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:24796konquistador10https://www.infopathdev.com:443/forums/thread/24796.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=24796<p>How to fill out a field(text box) in Infopath 2003 from a table in an&nbsp;external data source like Access .</p> <p>Thanks a Lot&nbsp;</p> <p>&nbsp;</p>