InfoPath Dev

Any suggestion?

I have a database with one parent table and many child tables. I have designed a WebServie based on those tables and defined constraints and relationships exatctly as databse. I have some questions: (1)Because all child tables have non-indentifing relationship wiht parent table, there are a Primary Key(define by child table)and a Foreign ...

In SQL database, there are one parent table and some child tables which has non-indentifying relationship with parent talbe. I have designed a WebService based on those table and desing a InfoPath sheet based on that WebService. But how let the child repeating section in Infopath sheet automatically fill the foreign key migrated from parent table?

I met problem when I write WebService for a database The simplified database model like this: Create table [CreditReport] ( [CreditReportID] Integer Identity(1,1) NOT NULL, UNIQUE ([CreditReportID]), [ReportType] Nvarchar(10) NULL, [ReportNumber] Varchar(20) NULL, Primary Key ([CreditReportID]) ) go Create table ...

As metioned in MSDN ''The InfoPath implementation of DataSet objects ignores embedded columns with different namespaces. Furthermore, ADO.NET DataSet schemas do not support the xsd:any structure. As a result, data fields within the InfoPath form's DataSet structure cannot be bound to rich-text controls, because the XHTML namespace is ignored. ...

Many thanks for your help! I will try to use the first solution because it's so hard to keep synchronicity between Infopath and SQL database design if use second solution.I am not clear about how to define a strongly typed dataset in Webservice(especially for XHTML type), is there any exapmle about it?

I wrote a Webservice for SQL database, and use that Webservice as the datasoure of an InfoPath sheet. There are some NVChar fields in SQL database tables, I want map those NVChar fields to Richtext box controllers. But I found all TYPE of those NVChar field are ''string'' in Infopath, I can not change the type becasue ''Data Type'' choose field in ...

Thanks for your help!My problem is that if you created an Infopath form based on a Database Connection and the database you used contains any BLOB type datafield.The ''Submit'' function Infopath should support will be useless and the ''Submit'' icon on the toolbar will be gray too. I have checked some MSDN documents and solved that problem by ...

When I used a SQL 2000 table as datasource I found that ''Submit'' function is useless because one of datafield of that table is ''image'' type. So how can I submit a Infopath form with ''long'' type datafield?