If you are going to develop a functional ERP system, filtering of data within the screen is essential specialy if that system has a large volume of data. To filter the data in an Auto Complete Box (a native combo box of Microsoft Lightswitch) inside a datagrid using other fields which resides on the same datagrid just follow the steps below:
1. Make a new query just for the Auto Complete Box and make sure that it has a parameter value that is use to filter the result. Below is an example of such query:
2. Tie up the query to the Auto Complete Box.
3. Now filter the query using one of the fields in the DataGrid.
That’s it. In the screen below I filtered the Subsidiary Auto Complete Box using the value in the Account Auto Complete Box, both fields resides in my Journal Voucher Lines DataGrid.