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 / November 2007

Tip: Looking for answers? Try searching our database.

Secondary data connections

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ed - 12 Nov 2007 20:00 GMT
I have a form that was created by someone that does not connect to an acces
db. I am trying to get an account ID lookup to return the account name to
work. So I have a secondary data connection that contains this 2 field
query...acct # and acct name.  Is it possible to get this to work. I am
pretty new with Infopath. This form contains several places where one could
do lookups for various account lookups.
How can this be done in an existing form? Thanks ....
Paresh - 13 Nov 2007 08:54 GMT
> I have a form that was created by someone that does not connect to an acces
> db. I am trying to get an account ID lookup to return the account name to
[quoted text clipped - 3 lines]
> do lookups for various account lookups.
> How can this be done in an existing form? Thanks ....

Hi Ed,

Yes this can me achieved using secondary dataconnections.
If you are dealing with browser based form, then you can write a web
service method to achieve the desired task.

Do let me know if you need more information.

Regards,
Paresh
Ed - 13 Nov 2007 14:01 GMT
Hi
Thanks for your response. This is NOT a browser based form.
I tried creating a rule but nothing happened. If I have to write code,
is there a sample piece that I can look at that shows how to do this.
But again, this is not a browser based form. Can I still query fields.

Ed

> > I have a form that was created by someone that does not connect to an acces
> > db. I am trying to get an account ID lookup to return the account name to
[quoted text clipped - 14 lines]
> Regards,
> Paresh
S.Y.M. Wong-A-Ton - 16 Nov 2007 07:00 GMT
Try this article:
http://enterprise-solutions.swits.net/infopath2003/autofill-fields-dropdown-sele
ction-secondary-data-source.htm

While it makes use of an Access database as a secondary data source, you can
use any type of secondary data source (XML file, SharePoint list, etc.).
---
S.Y.M. Wong-A-Ton

> I have a form that was created by someone that does not connect to an acces
> db. I am trying to get an account ID lookup to return the account name to
[quoted text clipped - 3 lines]
> do lookups for various account lookups.
> How can this be done in an existing form? Thanks ....
 
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.