By default when showing a list of filter values (or a list of distinct column values when building a query) AdapTable will create the distinct list based on what is currently in the DataSet.
However sometimes you might want to provide AdapTable with a list of allowed values for lookups or filtering. You do this through the getColumnValues property of Query Options.
This property allows you to provide a method which will get the distinct values you want to show from the Server and return to AdapTable. If the return list is empty then we will show the list from the grid as normal.
This example provides custom value list for the 'Cust. Ref' and 'Contact' columns. When you filter on these columns or use them in a query only a subset of values are shown; other columns display distinct values normally.