Filter the contents of a dropdown list by adding additional WHERE clauses in the Query Wizard.
In the example below, the contents of CompanyNameFilter are restricted to only those companies located in London.
Step 1: In the Layout Editor, select a FieldFilter dropdown control.
Step 2: In the Property Sheet, Queries section, select the appropriate query and open the Query Wizard (Edit…).
Step 3: In the Query Wizard, add a new WHERE clause containing a formula that restricts the contents, e.g.:
= “London”
Step 4: Build and run your application.