Grid's problem

[foxwizard]

Hi guys,

I have established a relationship between two tables. The parent table is in the main form while the child table is in the grid of another form. My problem is, all the records in the child table is being displayed in the grid. I only need to display only those records that satisfy the same batch number of the current batch number of the parent table. Example: If 1 batch of the parent table corresponds to the 5 records of the child table, these 5 records will be displayed in the grid. The problem is, all the records were displayed. To give you more info: I have set the Linkmaster property to parent table and RelationalExpr property to batch ( the common field of the parent and child).
I'm using vfp 6.0.

Thanks in advance.

Bren

 

[foxwizard]

Additional informations:

I did not use the command "SET FILTER TO batch = m.vbatch" because it will eat up all my memory due to volume to transactions.

Thanks.

Bren

 

[Mike Gagnon]

foxwizard

Are the two forms part of a formset? Otherwise it will not work the way you expect. You would have to send a parameter to you child form and set the filter on the value received. Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first

 

[monikai]

hej !
In this case i use grid souce as cursor from select statement:
select ... from..... to cursor..... where batch = m.vbatch
and refresh.grid.
Kind regards from Warsaw !!!!!
Monika (monikai@yahoo.com)