I have a form with 2 grids. I want to display records in second grid(Line grid) according to the selected record in First grid(header grid) i.e, I need to filter records in second grid… How to do that?? I am using query as a datasource on a form.
As shown in figure, there is a common field named Activity number… Now, I need to display records in Second grid for selected record in first grid(Say VA-00015).