Topic: Tablegrid, sub-grids and sql search
Hello Dmitry,
In a project i have just started, Form1 has 1 main Tablegrid, 2 sub-Tablegrids and 2 incremental sql-searches.
In the following example, when I start, Form1 looks like this (screenshot1).
I use an incremental sql-search on Tablegrid1 which retrieves 3 rows into Tablegrid3 (screenshot2).
I then use the second incremental sql-search on Tablegrid3 which reduces the rows from 3 rows to 2 rows (screenshot3).
If I want to try a different search on Tablegrid3, I delete my criteria but instead of looking like (screenshot2) which is what I expected, it now looks like (screenshot4), showing ALL rows.
To make it look like (screenshot2) again, I need to go back and re-highlight or re-enter the selection in Tablegrid1.
I think there is something that I've not set up correctly but I cannot find it. Can you help?
I have enclosed a copy of the project and I am using Version 1.50.
Thanks,
Derek.