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/16820.aspxThu, 22 Jun 2006 15:07:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16820Ptrudell0https://www.infopathdev.com:443/forums/thread/16820.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16820I have two problems with a Leave Request Form we need for our Office. I have a Main Connection with two Tables a Login table which has their staffs First Name, Last Name, Team etc. And a Leave Request Table which list all the request for leave made by staff. <br /><br />The form is in several parts. The top is the Login ID , which is designed to populate a section with First Name, last Name, & Team. <br /><br />The Second Section is for entering data for a Leave Request to be stored in the Leave Request Table. (A repeating Section). <br /><br />The first problem is when I design the form to retrieve data in the first section from our database - Login table, based on their login ID I get everything that is in all their Leave request in the second Section. <br /><br />The second Problem is , if I base the top section on a secondary connection, using the Login Table to retrieve First name, Last Name, team. I get the form fine, but when I process the form to e-mail to a Supervisor, the form arrives to the Supervisor with blanks in the Name & team Fields. <br /><br />So I've got several things wrong here appreciate any help. Thanks.