Submitting to two Tables

[Skribo]

I have a InfoPath Form based on a Access DataBase (Industry and Company
Table which have a many to many through a IndustryCompanyJunctionTable)
In InfoPath the Main DataSource is the company Table with the
IndustryCompanyJunctionTable added. Now I want to either select an exsisting
Industry for the Junction Table or write in a new one. Because there is now
combo Box i tired to do it over an Other Industy Field, but than I can't
submit to the Industry Table because its not a Main Datasource...
Is this the wrong way to go about it? Should I restructure the Access
DataBase?

Thanks for your Help

 

[Adam Harding]

Skribo

Infopath does not like many to many, better of having one table or better
still a one-to-many relationship with each industry having one or more
companies within it. That way Infopath will have no trouble with it at all.

Cheers Adam