InfoPath Dev

I have a database connection with 2 tables. One I am querying to see if a record exist, then if the record does not exist I should add the data to table two. whenever I try to submit the data - I get an error massage which tells me it is trying to write to table one and not table two. How can I make sure it is writing to table two. the ID Field is required for Table one but the ID field is not required for table two. What can I do to make sure I am writing to table two and not table one. Thanks Carol

 Hi - we had a brief chat over email on this, but just to answer this question - if the form is a database bound form, you'll have to write code for this to change the connection for the Main data source prior to submit.