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 ...

 Hilary,         Thank you so much.   I am just getting a chance to look at this today and I cannot say how much I appreciate you reaching out to help me. I will apply this to the form,  just as I thought, You are the best.   Thanks Carol  

 Yes, XML is what is accepted.   Thanks 

 No it is not valid - I was just trying anything that may work and it does not work.  I did that after watching a video - but it did not help    I would like to change the Address 2, City, State, Zip entered in the ...

( Note - I will send the ID Privately) http://production.shippingapis.com/ShippingAPITest.dll?API=Verify &XML=<AddressValidateRequest USERID="0000000000">   <Address ID="0"> <Address1></Address1> <Address2>6406 Ivy ...

 The Result will be the Address, city, state, and zip5 & Zip 4 code    if the address is valid  or a message with "Invalid Address" if it was not valid.   Thanks 

 Thank you -  This is my very first InfoPath form and I really don't know what I am doing -   Carol 

Error message - Invalid number of artuments - concat("http://production.shippingapis.com/ShippingAPITest.dll?API=Verify&XML=USERID='000000000000'&IncludeOptionalElements='true'&ReturnCarrierRoute='true'&$select=ID,Address2,City,State,Zip5,Zip4,DeliveryPoint,CarrierRoute,&$filter=Address2[. = ...

 I am working on an InfoPath form (For the first time) with this form I am able to do the following I am able to do validation to against a SQL database to see if an address is in the database (if it is) I display a message " Already Exist"If it does not exist -  I do a rest call -   Now ...