InfoPath Dev

I've been using an InfoPath form for a while without a problem. Recently, I added a field to the database, then went bank into InfoPath and added it to the form. However, when I did that, it broke submit. The option for enabling submission is grayed out and I get the error message "A many to one relationship might exist between two tables in the data source." Well, duh, I want it that way and it was never a problem before. Also, in Data Connections, it shows the type as "Retrieve data from database," but this isn't what I want, I want to put data in the database, but I can't figure out how to change it. Can anyone help me?

How did you add the field to the form?

If it's a database-bound form, I don't think you can just add a field to the schema. I think the schema needs to be refreshed based on the updated SQL table.

At first I added it to the database then to the form, but it was unbound and wouldn't submit info. I ended up deleting the unbound form, and as you said, refreshed the available fields via "Data Connections." The new field then appeared in my field list and I added it to the form. That's when submit stopped working.