My program uses a set of grids to display data. Using Set Relation command the program displays data from various tables in the corresponding grids, depending upon the data displayed in the Master Grid.

Sometimes there might not be any data corresponding to the master grid in one of the child tables, in which case, the grid should be just empty. But somehow when this happens, instead of being empty my grid displays all the data from the corresponding table. And if it finds data that is to be displayed for one search,then in the following search, if there is no matching data, it displays the prevoious results.

Any help woule be appreciated.

Ria