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 - 11 May 2006 13:57 GMT
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
> I have a InfoPath Form based on a Access DataBase (Industry and Company
> Table which have a many to many through a IndustryCompanyJunctionTable)
[quoted text clipped - 7 lines]
>
> Thanks for your Help