SQL Database Integration

Re: How to submit to multiple database tables with one-to-many relationships?

cguruc — Tue, 06 Apr 2010 19:55:14 GMT

hi, i've been experiencing same issue.

I have 2 tables CUSTOMER and REQUESTS table. Both tables has "ID" as a primary/unique key. And i have joined both these tables by "customerid". When i use access as a back end DB, i have no problem submitting with the same primary key and relationship. However, I now require to change the DB to SQL and it does not allow me to submit anymore. I checked the Data connection wizard and right at the end, it says "Submit option: Disabled. A many to one relationship might exist in the data source."

What am i missing??? please help!!!

Re: How to submit to multiple database tables with one-to-many relationships?

geoffc — Fri, 14 Nov 2008 15:10:19 GMT

this has been fixed. I noticed that the dba added an additional primary key to the main table so there was indeed a many-to-one relationship. I got this key removed and it will now submit. thanks for your help.

Re: How to submit to multiple database tables with one-to-many relationships?

Hilary Stoupa — Wed, 12 Nov 2008 17:25:19 GMT

But your main table is your 'one' table, right? and then you added another table, and created a relationship? Try selecting your main table in the wizard and clicking the modify button, and deselect the multiple records box for that table....

Re: How to submit to multiple database tables with one-to-many relationships?

geoffc — Wed, 12 Nov 2008 16:54:57 GMT

on the last screen it is actually saying a many-to-one relationship might exist

Re: How to submit to multiple database tables with one-to-many relationships?

Hilary Stoupa — Wed, 12 Nov 2008 16:34:15 GMT

On the last screen of the data connection wizard, are there specific reasons given for Submit not being enabled? I don't recall having it disabled because of one-to-many before....but it has been a while since I've created a DB bound form.

How to submit to multiple database tables with one-to-many relationships?

geoffc — Wed, 12 Nov 2008 13:24:37 GMT

Hello, I have an infopath form that is currently connected to a SQL server database. There are a few tables I would like the data submitted to, but it appears as though the submit option is disabled because there is a one-to-many relationship between some of the tables. Is there a way around this? The one-to-many relationship is being used because repeating tables are used in the form. Any help is appreciated. Thanks.