This customization filters the contents of a dropdown list box whose data comes from a foreign-key field. The dropdown list box is used in an Add Record panel or an Edit Record panel. You can add the filter to the dropdown list box which will return a subset of values for the dropdown.

For example CustomerID field in Orders table is a foreign key to the CustomerID field in CustomersTable. The CustomerID dropdown list in an Add Orders Page is populated from CustomerID field in the Customers table. You can add this customization to filter the CustomerID dropdown list to display only those CustomerID where Country='USA'.

This customization will be added in:

..\<Application Name>\App_Code\<Table Name>\Add<Table Name>.Controls.cs

For example: C:\MyApp1\App_Code\Customers\AddCustomers.Controls.cs

Step 1:  Use this wizard to add code customization.

Step 2:  Build and run the application.

This customization only applies to an Add Record, Edit Record or Edit table panels with one or more dropdown list.