InfoPath Dev

Hi,

I have one InfoPath requirement, in which I have to diaplay the data in combo boxes from 3 different tables and on the basis of this display info from these 3 different tables I have to submit 3 enteries like Lot number, Product Number etc in another table.Can please someone help me.How should I start, should I start by creating the from from New Datasource or something else, how I will be able to submit the data in another table?

Really appreciate your help.

Thanks,
Raj

Hi Raj,
U can create a form using the "New Blank form" option.
Create 3 "Receive" dataconnections to the 3 different tables and bind it to ur listbox so that the values from the 3 tables are displayed in ur list box.

Now use the "Submit" dataconnection to submit the 3 selected fields to a webservice which inturn inserts it to a different table.

Regards,
Abhishek

Hi Abhishek,
Thanks for the reply, here is one more question, the data that I have to submit will not be from these three tables, that is different field related to my fourth field where I have to submit the data.One more query I can submit only through web service and if yes then how can I submit through web service(what I need for this?), I can't direct submit the data direct into the database?

Please advise.

Thanks,
Raj