InfoPath Dev

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

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?

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

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.

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.

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

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

Thanks for the help!

Chip