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/59977.aspxWed, 06 Oct 2010 06:44:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:59977Patrick Halstead0https://www.infopathdev.com:443/forums/thread/59977.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=59977<p>Hi Aadair,</p> <p>This is why we developed our Database Accelerator (<a title="DBXL" href="http://www.qdabra.com/en/products/DBXL.aspx">DBXL</a>) for InfoPath in 2004. Take a look a the free trial download. It&#39;s an inexpensive tool that can help you solve your reporting problem in a very short amount of time. </p>https://www.infopathdev.com:443/forums/thread/59519.aspxFri, 01 Oct 2010 14:48:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:59519aadair0https://www.infopathdev.com:443/forums/thread/59519.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=59519<p>I am very new to InfoPath and need to use information from one SQL Table to another using a one to many relationship.&nbsp; What I have is one table called Input (this table has the information from the database) and a second table that is blank called Adjustment (this is where I would like to have any adjustments that need to be made as well as comments, this table will have the ability to have several adjustments that can be made for one single line record from Input table).&nbsp; I have got this to work with a one to one relationship, but unable to get it to work for a one to many relationship.&nbsp; Also, works really good if&nbsp; I only use one table, however that table has to be updated nightly and will wipe out the adjustment information.&nbsp; I have played with this for a few days and cannot get it to work.&nbsp; The whole goal is to be able to submit all inputed information to the adjustment database and be able to link the two tables to create a management report that could show every adjustment that need to be made for a single line item in the input table.&nbsp; Am I going about this the wrong way and need to take a different approach&nbsp;to accomplish my goal?&nbsp; Thanks for any input.</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p>