>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.
Or 5) a parameterized view using the parent key as the parameter? This has the advantage of allowing you to show lookup field descriptions if you have fields storing ID fields from lookup tables. Updateable views allow you to change the child tables easily.
Barbara