InfoPath Dev

Hi, Iam very new to infopath. I'm trying to design a mortgage form. I want the form to be link to 3 different table from a database from sql. can someone give me the right steps to do, to have two data source. The 3table from sql is just borrower information, coborrower information and borrower-coborrower.

*borrower info table has a primary key that is link to a foreign key at borrower-coborrower table.

*coborrower info table has a primary key that is link to a foreign key at borrower-coborrower table.

*i want to have a firstname field for borrower information and firstname field for coborrower information in one form. i would like the database to be updated when i click the submit button from my form.

Hi AubreyNigoza and welcome to our forum!
Do you want to retrieve the data from the database or submit the data from the database or both?

Patrick Halstead [InfoPath MVP]
InfoPathDev

Patrick,
I would like to be able to received data and submit data but of it is fine if i will have separate forms for receiving and submitting data...i hope you can reply asap... i appreciate your help

Hi again,
I cannot reply ASAP because I have a day job. We provide this forum for free. If you want ASAP response, then send me a check and you'll have faster replies ... :) Anyway, for a multi table read from the database where you need to support submit, you're best off buying our Database Accelerator (see Downloads). Then you can do it with no code and specify the mapping to the tables using the IAT config tool. Otherwise, you'll have to write a bunch of code.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Patrick,
I apologize for that...thank you for your help. One last thing do you know a site where i can pull off the codes to be able to submit to a different table.just if you know cause iam curious about the codes

No, I think we have more code on our site than any other. I will ask Agni to post some HowTo examples of using code to access SQL. There is also some code in the SDK, but you're going to have to do some development yourself to form the query and handle the results.

If you want to do this fast, my recommendation is to download the free evaluation of the Database Accelerator and use that (it's good until Sep 1st). That way, you don't have to write any code.

Patrick Halstead [InfoPath MVP]
InfoPathDev

parick,
thanks...i might buy the database accelerator...i would like to know if i will get a free update once you updated the progam. it's really cool