Query and filter on related columnsPosted: 2012-03-05
I want to give you a way to filter a repeating table with the help of a drop down.
Let’s say you have a list with with a column called Requests and one column that is called Defects. You could have multiple defects for a request and now you only want to show thoose defects for the request you have choosen.
First add a data connection to receive these three columns from your list.
On your form, add a drop down and configure it like this.
Now add this secondary data source as a repeating table to your form and delete those columns you don’t need to show in the form. Deleting them from the form doesn’t mean that you delete them from the data source, they will still be there if you need them. Afterwards it could look like this.
Let us add the rule to the repeating table that will do the trick.
Highlight the repeating table and click the button Manage rules in the ribbon. Add a new Formatting rule that looks like this.
The condition says: When”Request” in the secondary data source “is not equal to” the “MainRequest” in the main data source.
Now when you test the form you will be able to see only those defects that belongs to the request you choose.