Form Designer: How to filter a drop-down list

[eddy.daouk]

Hi Rami,

The Form Designer can only support one filter.

Here is how you can achieve what you need using code behind:

How to configure a data source with a parameter based on a form field value from code-behind

The sample process below shows how to configure a custom SQL datasource to populate a drop-down list. The SQL datasource has a parameter named ID_DIR in the SQL command WHERE clause. This parameter receives the selected value of the form’s REQUEST_DIRECTORIES drop-down list. It is possible to add multiple parameters to the same SQL command in this way. string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MainDbSource"].ToString(); string providerName = Sys…

Best Regards,
Eddy.