Data Connections

Re: Multiple Parents

chipdavis — Fri, 28 Jul 2006 03:32:02 GMT

Thanks for the help!

Chip

Re: Multiple Parents

Greg Collins — Wed, 19 Jul 2006 17:20:02 GMT

Yes - that is correct. Only a single submittable SQL connection. You will need to use a WS if you want multiple submittable connections.

Re: Multiple Parents

Stavi — Wed, 19 Jul 2006 14:48:23 GMT

Matt I dont think that would work either, as far as I can tell you can only have one submittable sql data connection. You can create more sql connections but they will be receive only connections

Re: Multiple Parents

Matt Faus — Tue, 18 Jul 2006 17:17:39 GMT

You could just have several data connections to the same database, each one connecting to a different table. I think this would be what you are trying to accomplish, although it will require the use of several DCs.

Re: Multiple Parents

Greg Collins — Tue, 18 Jul 2006 17:04:52 GMT

I believe that Stavi is correct. If you want multiple top level tables, you'll need to write a Web service to do that. The database connector in InfoPath just won't let you do that so far as I've been able to figure out.

Re: Multiple Parents

Stavi — Tue, 04 Jul 2006 21:29:26 GMT

By parent I think he means the first table you add to a datasource, if you add any more tables you have to choose a field so infopath knows how they are related (as such 2nd table is child), he doesnt want to do that, he wants several top level tables

I dont think you can, as far as i know all tables in the datasource must be related

Re: Multiple Parents

Greg Collins — Tue, 27 Jun 2006 18:06:46 GMT

Please provide more information about what you mean by "parent" and "child" tables.

How are you currently using these tables? What are you trying to do.

Are you referring to the master/detail control, or something different?

Multiple Parents

chipdavis — Mon, 26 Jun 2006 21:13:15 GMT

Is it possible to have multiple parent tables in a single InfoPath form? If I add a second table, it always ends up as a child.

Thanks,

Chip