Ria,

You might want to look at using two parameterized views for the child and grandchild tables. There's an example over on my website if you've never tried using them.

>My program uses 3 grids to display data from 3 tables. The user will query on one of the tables and the resulting form should display the data from that table in the first grid and the child records corresponding to this record from each of the other tables in the other grids.
>
>The program uses Set Relation command so that the child records will be automatically selected.