InfoPath Dev

My infopath form is connected to a SQL Server Database in which I created four tables:
1. tbl_main
pk: main_id
fk: address_id (from table2)
fk: employee_id (from table3)
fk: service_id (from table4)
request_date


2. tbl_address:
pk: address_id (identity(1,1)
street
state
country
3. tbl_employee
pk: employee_id (identity(1,1)
lastname
firstname
4. tbl_service
pk: service_id (identity(1,1)
service_type
The form contains some text fields and dropdown boxed which are based on those 4 tables.
My question is:
Should I use "new from data connection" option when I create the form? If so, which table should I set as a main data source?
How I can I insert new address_id, employee_id and service_id into tbl_main table once users enter some new record into those
three tables?

Hi Fly,

check out these two links I guess they can help you (Lab9 ADO DataSet):
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ip2003_tr/html/odc_INF_Lab_04.asp

http://blogs.msdn.com/philoj/archive/2005/11/08/490200.aspx

Hey Fred,

You might take a look at this thread, it seems to be similiar:http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=3191&SearchTerms=one-to-many

If you can't figure it out in the IP interface (it might not be possible), I would recommend either writing a custom web service, or using our generic one, called Database Accelerator to shred the XML forms into your database. Note that the generic one should be much easier to implement, maintain, and expand.

http://www.qdabra.com/proddetail.asp?prod=QDBXL1