https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/70159.aspxThu, 08 Sep 2011 17:37:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:70159Rae0https://www.infopathdev.com:443/forums/thread/70159.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=70159It looks like a one-to-many relationship is perfectly fine, so far, and remarkably easy. Just set up the tables in SQL, base a form off the data connection, and go. All other troubles are automagically gone. I just dragged my top repeating folder into the place that says &quot;drag data fields here,&quot; chose Repeating Table with Controls, and ended up with basically what I got in my other version of the form, except that everything works now. <p> So basically, all the things that I was asking for in this thread, as well as my issues with <a href="http://www.infopathdev.com/forums/p/20201/70091.aspx">putting a repeating table in a repeating section</a> and <a href="http://www.infopathdev.com/forums/p/20221/70158.aspx">getting the right data back into that repeating section</a>, were fixed by choosing a one-to-many relationship and using two tables in the database instead of a (very convoluted) singular table.https://www.infopathdev.com:443/forums/thread/70094.aspxWed, 07 Sep 2011 13:58:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:70094Rae0https://www.infopathdev.com:443/forums/thread/70094.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=70094Yesterday I asked a question about a <a href="http://www.infopathdev.com/forums/p/20201/70091.aspx#70091">SQL-receive repeating table in a repeating section</a>, and I got an answer that probably would have been perfectly fine if the project spec didn&#39;t suddenly expand. <p> Now, I need to put a SQL-submit repeating table in a repeating section. <p> I created a form from a data connection, made the repeating table, and with some creative (and probably not best practice) rearranging ended up with a form that has a repeating table with some of the fields and a few separate text fields that have the rest of the fields. I&#39;ve got everything stored in one big table in the DB, even though the separate fields should be the same value for every row of the table in a particular instance of a repeating section. If this is confusing...well, just imagine how I feel. <p> When I try to create a repeating section to stick all of this in, it requires that I bind it to something in the data source, even though I don&#39;t want to. When I just attach it to the data fields from the DB like in the repeating table, and then put the table in the section, InfoPath says the data won&#39;t store correctly. When I try to preview it, I can insert new items in the repeating section, but not the repeating table - even though there is still an &quot;insert item&quot; button. <p> Is this sort of thing not allowed? Would I be better off trying to use a one-to-many relationship in the DB and arranging the form that way? If so, how do I do that? Everything I&#39;ve found while trying to Google it has been related to Access databases, (like this otherwise <a href="http://office.microsoft.com/en-us/infopath-help/how-to-guide-connecting-an-infopath-form-to-an-access-database-HA001119950.aspx">useful-looking how-to guide</a>), which is a bit of a concern. Would a one-to-many relationship work here? Or do I need to do something else entirely? <p> P.S. I&#39;m using InfoPath 2003, and Microsoft SQL Server 2005 <p><p> <strong>Edit:</strong><br /> I&#39;ve found that I can add a new group that&#39;s apparently unattached to the DB, and attach the repeating section to it, and it *almost* works (if I use current() I may be able to force it to work...right now everything in one instance of the repeating section gets copied immediately into all the others), but my main question still stands - <strong>should I be using a one-to-many relationship, and if so, how do I do that?</strong> Thanks.