InfoPath Dev

I have an InfoPath form that needs to be able to submit to multiple SQL tables. I have modified my SQL tables to have the main/parent table contain only one key, the primary key, and no foreign keys. The other/child tables that are then added to the connection do not contain any keys on the SQL side but are connected via a relationship in InfoPath. When I add any table that is not connected via a relationship with the Primary Key of the parent table, I get a 'Disabled Submit / Many to One relationship might exist' on the last screen of my data connection set-up. Is there any way to have child tables that do not have a relationship to the Primary Key of the parent table and still be able to submit? If I cannot get this to work I will be forced to have multiple forms that use these other tables as the main connection to get the data submitted back to all of the tables. ANY suggestions are much appreciated!!

 We generally do not recommend submitting directly to a database from your form, because that database binding places a lot of restrictions on what you can do with your form. It's for that reason that we created the DBXL web service to stand as a loosely-coupled intermediary between your form and your database. It should be able to accomplish the task you are trying to do within a single form if you use DBXL. I recommend having a look:

http://www.qdabra.com/en/products/DBXL.aspx