Solved

Infopath secondary datasources nested

Posted on 2009-04-02
3
618 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Submit infopath form to library/list and sql 7 1,013
Infopath Custom Code Issue 7 358
Infopath VBA to submit to poptional databases on Submit_Clicked 12 474
shrepoint lookup 4 140
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…
Knowledge base software has turned out to be a quite reliable method for storing information, promoting collaborative work and for sharing valuable input and solutions.However, some organizations are trying to develop a knowledge base that works wit…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now