Populating two SQL tables in InfoPath

[DarrylGould]

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

 

[Zhang Haiguang]

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

 

[DarrylGould]

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








- Show quoted text -

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

Thanks

 

[INTP56]

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