TAdvStringGrid: Second Filter should only show possible values after first filtering (like Excel)

[Janecek_David]

Hallo,
I want that our filtering behaves like in excel:

1. TAdvStringGrid looking like this f.e.:

+---------+----------+-------+
| Surname | Lastname | Money |
+---------+----------+-------+
| Max     | Müller     |    10 |
| Max     |  Schneider |    20 |
| Peter   | Franz      |    30 |
+---------+----------+-------+

2. I filter the first column for "Max"
3. Now If I do a filtering for the second column, I only want to have the values "Müller" and "Schneider" offered in the dropdown
4. I enter "Müller" in the second filter
5. Now I want to only show "10" as possible value in the filter dropdown in the third column.

How can I achieve this? We always get all initial values of the whole, unfiltered grid.

Thansk in advance.

[brunofierens]

set grid.FilterIncremental = true

[Janecek_David]

That was easy. Thank you very much! Works like a charm!