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/17307.aspxSat, 17 Jun 2006 05:11:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17307Kalyan Gaddam0https://www.infopathdev.com:443/forums/thread/17307.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17307Hello, <br /><br />Please read the link below<br /<a target="_blank" href=http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2422>http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2422</a><br />also take a look at this link to know about Database Accelerator <br /<a target="_blank" href=http://www.qdabra.com/proddetail.asp?prod=QDBXL1>http://www.qdabra.com/proddetail.asp?prod=QDBXL1</a><br /><br />There are many posts in this Forums which will answer your problem.https://www.infopathdev.com:443/forums/thread/16817.aspxFri, 16 Jun 2006 19:09:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16817Ptrudell0https://www.infopathdev.com:443/forums/thread/16817.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16817How do I retreive data from Database Queries, not just the Tables. I have special function fields in those queries and need to be able to retreive that dat to a form, add data to the form and then drop some of that data back to the database. <br /><br />It's a Leave Request form, and we want to be able to show the staff their current leave balance, which is calculated in a database query. <br /><br />Appreciate your response. Pete