I have an InfoPath form connected to a database. There are several tables
into which the form feeds data. Each table has a common key so they are all
in the main connection. There is a drop-down list at the top of the form for
the user to select the appropriate key. When this is done, all the tables on
the form are populated with the corresponding data in the database.
If none of the tables have any data and I insert a new row in one of them, a
new row is automatically added to every table. This causes the user to have
to go delete the rows in the other table before submitting the form due to
required fields in those tables.
How can I stop InfoPath from inserting a new row in every table? Keep in
mind this only occurs when none of the tables have any data to begin with.