>More info.
>
>I create a new form form scratch using the basic VFP form, added my 2 tables in the DE, put the relation. On the form I put one txt box (no source code) one grid with two columns (record type is alias and record source is the child talbe. column data source are the two first fields in the child table) and a command button which will seek the parent table for the value I enter in the txt box. Everything is basic VFP6.
>
>When I search for a parent record with childs it takes 1 or 2 seconds.
>When I search for a parent record WITHOUT child it takes 2 minutes.
>
>I tailored the delay to be during the grid.refresh() method although I put nothing in there myself.
>
>Is it a normal behavior in VFP6?
>
>TIA

Hi.
Just for the sake of experiment.
Clean the form's DE.
Wrap the form in a prg.
Open your tables and establish relations in the prg.
DO FORM yourform

All the best