Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / May 2006

Tip: Looking for answers? Try searching our database.

Submitting to two Tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Skribo - 11 May 2006 09:49 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.