This would be a lot easier if you used parameterized views for the children. I've had mixed results getting grids to display children properly with relations. If you use views, you just change the parameter that you use for the filter (IOW, the foreign key to the parent), and REQUERY the view.

>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