>>I want to maximize the speed of performing calculations in related tables. I will be performing a REPLACE on every record in the child table based on values in the Parent record. Any thoughts on the best performers ?
>>
>>1) Using Set Relation to 'automate' finding records in child tables
>>
>>2) Using Set Filter to 'manually' SKIP thru records in child tables based on Parent key.
>>
>>3) Using Scan For in child table based on Parent key.
>>
>>4) Using good old fashion Seek in the Child table based on Parent key.
>
>Peter;
>Try to stay away from FILTER as much as possible. In dealing with child records, I usually use the SELECT command and include RECNO() as a column. Then use the record number to point directly to the record in the child table.
>
Oh I like this myself!
SELECT RECNO() AS myfield
Is that what you mean Kia? That's an interesting approach I have never considered before.
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos