Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Infopath secondary datasources nested

Posted on 2009-04-02
3
Medium Priority
?
628 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 2000 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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…
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

886 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