Filtering on related data column

 Top  Previous  Next

As we know, between two data sources, a relation can be set. See more details in the "Data" chapter. With the help of relation, it is possible to filter data in the source, by using a data column from a different source.

 

Assuming, you have placed on the dialogue a ListBoxControl and indicated the following data column in the "DataColumn" property:

 

Products.Categories.CategoryName

 

How will filtering work?

 

•when filling the control with values, the "CategoryName" column from the "Categories" data source will be used;
•the filter will be applied to the "Products" table. Those data rows will be filtered for which the following condition is correct:

 

the [Products.Categories.CategoryName] contains one of the values, selected by the user