Question: I am filling a value table from a query and outputting the it to a form, I have also added fields on the form for filtering. Each time a filter has changed, I need the value table refilled from the query taking into account the currently set filters. How can I realize this?
Answer: On create at server event of the form and on change events of the filter fields all run the same FillTheTable procedure. Salient point here is how to exclude the filter parameters from the query in case the user hasn’t chosen any value for a given filtering field. Here is an example on how to do it: