Opening a form with a subset of data

The Filter properties on a relation are used to apply a SQL filter to show a subset of data when opening a form.

A form is typically opened with a set of data for the user to browse. This data set is controlled by the data set relationships and the where clause specified in the form record Query property. In some instances, you may want to open the same form with a limited set of data. To do so, in the BA diagram, add a filter on the relation to the form.

The Filter properties consist of the Destination Field to filter on (for example, country.id) and the Source Field values to use for filtering (for example, the value in account.country_id). When the form is opened, it will filter the results displayed based on the filter.