https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/9815.aspxThu, 25 May 2006 17:43:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:9815Matt Faus0https://www.infopathdev.com:443/forums/thread/9815.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=9815Hello Mike and welcome to the fourm!<br /><br />You should check out this HowTo:<a target="_blank" href=http://www.infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85>http://www.infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85</a><br /><br />It was meant for an XML secondary data source, but you should be able to use it with a database connection.<br /><br />I hope this helps!https://www.infopathdev.com:443/forums/thread/5624.aspxThu, 25 May 2006 16:48:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5624mnollar0https://www.infopathdev.com:443/forums/thread/5624.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5624I'm trying to create a termination form that will be connected to a single database connection that holds all of the personel data for my company. <br /><br />My form has four fields that list Emplopee Name, Job Title, Department, and Division. <br /><br />All of the data I need for these fields resides in my position control database, which I have added as a data connection. How can I setup the form where I choose the Employee Name from a drop down field and all the other 3 fields auto-populate with the correct data? <br /><br />Your help would be greatly appreciated.<br /><br />Thanks,<br />Mike