The designer layout for filters is exactly the same as the layout used when designing a form view. There are however two important differences:
- You can use a field several times in the view. When you are designing a form this is not possible, but when you are designing a filter you can. This behaviour allows you to have the same field in the filter multiple times for use with different comparison operators
- When browsing the data model, you can reach field in tables that are in a one to many or many to many relationship. When you are designing a form you can only reach fields in a one to one relationship
The last point requires a little more explanation. The data model displays fields (inside folders), tables and sub views. When a table is displayed () the name of the table is followed by the type of relationship that the view has with with the previous table. Form views are used for displaying data in fields and writing changes made to the data back to the database. For this reason form views only support using fields from the starting table or from tables that are in a one to one relationship with the starting table. You cannot use fields from a table in a one to many relationship in a form view.
This limitation does not apply to filter views as they are used to search data, not commit it to the database. Data from the starting table can be filtered based on values of data in a related table that is in a one to many relationship with the starting table.