>What determines the speed of a parameter view? I have a form with a pview based grid. The pview is a simple:
>select * from DETAIL where ID = ?pID
>
>In the Form.MoveRec() method there is something like:
>pID = MASTER.ID
>requery(grid.Recordsource)
>gird.refresh()
>
>MASTER has some 3,000 records and DETAIL 100,000
>
>It takes 25 seconds to requery the grid!
>
>If I change the grid to use the traditional approach, linking both tables directly, there is no apparent delay when changing records in MASTER.
>
>Both tables are properly indexed, have no relations set and no triggers.
>
>What am I missing?
>
>TIA
>
>Silvio
Do you have tag on DELETED() in 'detail' table?
Edward Pikman
Independent Consultant