InfoPath Dev

Hi. I have a problem when I want to Submit my data fields through a Web service in 2 ( or more ) Tables.
I don't have any problem with one table.
but when I want to sumbit my data fields in 2 tables,InfoPath gives the below error :
Dynamic SQL generation is not supported against multiple base tables.

(I'm using InfoPath 2003 and SQL server 2005 and a WebService that is coded with VS2005)

Hello Navid,

Please read the link below
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=3285

Hope it helps you

I have created a form in infopath Now I have to Enter the value in the form so that it should store in access database....please tell the procedure because just now i started to use infopath.

Hi msatish !
Would u tell more about your connections ?
How does your form connect to db ?
do u use any web service or u gonna to connect directly to your db ?

Thank u for your reply. my question is,, i have designed a  form in infopath and that form is connected to sql database .i have entered value in the text box field when i click sumbit the values has to enter to database and also to reterive that value from database .so please give the code for tthat i have installed .net in my system.

 

 

conncetion to db through sqlserver

connection to db through sql ...

I am using infopath 2007, using that i connected to msaccess through(tools---dataconnections----add---create a new connection ---receive data---ms sql server--select database---- connect to new data source ---odbcdsn----msaccess database---(from there i select the table name which i created ) and double click on it and i find the table name  and finally finish ) i got the error  connec tonly to sqlserver. so please help me out