Populating two SQL tables in InfoPath

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DarrylGould@googlemail.com - 08 Mar 2007 16:28 GMT

Hi

I have a strange query regarding SQL and InfoPath. I want to
populate two SQL tables from a single InfoPath form. When I create a
form based on the SQL database, I cannot see a way of adding another
Submit SQL table. Can anyone tell me how to do it?

Thanks
Darryl

Reply to this Message

Zhang Haiguang - 08 Mar 2007 16:41 GMT

If there is an relation between the two tables, you should add the two
tables to your data connection both. If you have added, I think InfoPath
could populate them automatically, you needn't to add the second submit sql
table by hand.

http://www.infojetsoft.com

> Hi
>
[quoted text clipped - 5 lines]
> Thanks
> Darryl

Reply to this Message

DarrylGould@googlemail.com - 08 Mar 2007 18:28 GMT

> If there is an relation between the two tables, you should add the two
> tables to your data connection both. If you have added, I think InfoPath
[quoted text clipped - 18 lines]
>
> - Show quoted text -

Zhang - I'm afraid there is no connection between the tables. Is it
possible to do it without a connection?

Thanks

Reply to this Message

INTP56 - 08 Mar 2007 19:48 GMT

I don't think that's possible. Two unrelated tables usually produce a CROSS
JOIN if you don't relate them somehow.

If they are really unrelated, use separate forms for each.

Bob

> > If there is an relation between the two tables, you should add the two
> > tables to your data connection both. If you have added, I think InfoPath
[quoted text clipped - 23 lines]
>
> Thanks

Reply to this Message