Secondary data connections

[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
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]

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 ....

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]

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

 

[S.Y.M. Wong-A-Ton]

Try this article:
http://enterprise-solutions.swits.n...-dropdown-selection-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.).