Solved

Infopath secondary datasources nested

Posted on 2009-04-02
3
622 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

734 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