Filtering dropdown lists based on user selection

N

NSNour

Dears,

i'm a new user to infoPath and need help regarding the ability to filter a
combobox based on user selection in another combo. the case is that i have 2
dropdown lists:
1- Category
2- Risks
Both dropdowns read from secondary data sources.
i need the Risks dropdown to be filtered based on the selected category.

waiting for help.
Best regards
 
A

Adam Harding

Quite easy once you get used to it

Populate the Risks from a secondary data source select the field you want it
to import and then click filter in the bottom right hand corner.

Specify to only show the risks where the categroy of the secondary
datasource belonging to the risk matches the category selected in the main
datasource ie your form. OK out of there and job done.

One note if it is a drop down list in a repeating table then you will have
to use the current() function. Look in this forum for info
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Dropdown filtering 2
Best way to display Mulitple comboboxes and dropdown boxes for a userform 0
Filtering data from a non-continuous list 3
Noob dropdown box question -- 2007 0
How to dynamic populdate data for dropdown list control? 3
Filtering DropDown data in a repeating table 1
How can Infopath spellcheck work on a form with long dropdown list 5

Top