InfoPath Dev

Ok, I was able to solve the problem.It doesn't really need any coding at all. Just for the benefit of others, here's a general description of what i did. I build two tables in SQL, the two tables should have primary keys in order for submit to work. I then created an infopath form based on the database. The two tables are linked as one-to-many ...

I want the user to enter the value of a control only in the first row, and then automatically assign that value to the same column every time the user inserts a new row in the repeating table is this possible?

I 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. To be more clear, ...