Solved

Infopath secondary datasources nested

Posted on 2009-04-02
3
621 Views
Last Modified: 2012-05-06
Hi,
I have an infopath form that has two external datasource
I query the first one from a button to populate a dropdownlist
I then want to choose an item from this dropdown list and press a button which will pass the vaule from this combobox to the second datasource.
how do I set the query field for the secondary datasource on change of the dropdown (this throws a state error when I try it), or is there a better way to do it?
Is there an event that fires on the refresh of a datasource?
0
Comment
Question by:sparksolutions
3 Comments
 
LVL 8

Expert Comment

by:MelMc
ID: 24050239
I'm not sure what type of control you have as your second field, but if you put value of the first drop down in teh default value (for a text box) or in the filter (for a drop down list) you will be able to get data returned based on field one, I do it all the time. Give me some more details (control types, current rules, etc) if you have more questions and I will try to assist further.
0
 

Author Comment

by:sparksolutions
ID: 24052574
I have username and password fields, with a login button button
when I click the login button, it calls a web service which populates a datasource called login, with name value pairs corresponding to questionnaires
This then populates a combobox
when I choose a questionnaire and click Load Questionnaire
it calls a web service and gets the questions for that questionnaire
It then populates the result set into a repeating section and makes the repeating section visible
just rename the file in the archive to xns
0
 
LVL 6

Accepted Solution

by:
ramuar1981 earned 500 total points
ID: 24372908
Add a rule to your dropdown with an action that sets the query value. Add a second action that then queries the secondary data source
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question