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/6448.aspxWed, 05 Jan 2005 16:45:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6448sooma0https://www.infopathdev.com:443/forums/thread/6448.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6448Ok, I was able to solve the problem.It doesn't really need any coding at all.<br />Just for the benefit of others, here's a general description of what i did.<br />I build two tables in SQL, the two tables should have primary keys in order for submit to work.<br />I then created an infopath form based on the database. The two tables are linked as one-to-many relationship on the primary key of the main table.<br />I then dragged the whole group from the data source section to the form, and choosed (repeating section with controls). This will do:)<br />When the user fills out the form and submit the data, it will be submitted to two tables with the general information saved in one and the repeating table information saved in the other table and the field on which the tables was linked gets autopopulated.<br />Hopefully this is clear enough.<br />https://www.infopathdev.com:443/forums/thread/6447.aspxMon, 03 Jan 2005 23:04:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6447Patrick Halstead0https://www.infopathdev.com:443/forums/thread/6447.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6447You will need to either structure your main data source such that the database returns a repeating table, or write some code to push back the repeating table values.https://www.infopathdev.com:443/forums/thread/6446.aspxSat, 18 Dec 2004 05:54:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6446Patrick Halstead0https://www.infopathdev.com:443/forums/thread/6446.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6446You'll need to do this in code using custom logic. It's not hard, and should only take 5-6 hours. Send me email at Patrick.Halstead at AutonomySystems.com if you'd like us to look at your solution.https://www.infopathdev.com:443/forums/thread/4521.aspxFri, 17 Dec 2004 18:24:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4521sooma0https://www.infopathdev.com:443/forums/thread/4521.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4521I have an infopath form that is based on a SQL database. I want to have a general section that should be filled by users all the time, and another optional section that contains a repeating table. I can't figure out how to design the database and the form so that the data in the repeating table will be saved in the SQL database.<br /><br />To be more clear, the general section contains information about the user and a project they are planning, the optional section has repeating table with fund source, account number, and amount of money controls. They can enter more than one fund source. And i need to store all these.<br /><br />I thought of building one-to-many relationship tables in the databse and base a master/detail control on it in the form, but the options available for submitting in the infopath form then won't include "save to a database", and i don't know the reason for that.<br /><br />Any help will be very much appretiated.<br />Thanks.