I am very new to InfoPath and need to use information from one SQL Table to another using a one to many relationship. 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). 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. Also, works really good if I only use one table, however that table has to be updated nightly and will wipe out the adjustment information. I have played with this for a few days and cannot get it to work. 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. Am I going about this the wrong way and need to take a different approach to accomplish my goal? Thanks for any input.