>Hi Naomi,
>
>Im using VFP version 9 SP1. The table's (CVdtl) main index is CVnoacct.
>
>The reasons i've asked about those 3 options are:
>1. I have 2 tables, 1 header and 1 detail tables
>2. Header tables re computes total amount based on details table as follows:
> 2.1. When user add, edit/modifies or deleted records/content in the detail tables
> 2.2. when user edit or delete from detail table, i want the cursor/record pointed to stay in that record after recomputing the header table's total. if i use select-sql for recomputing the totals, it does just like that since it computes using the temporary cursor and not the actual detail table. but when i use the do while or scan while using the detail table, the record pointer goes to the last record.
>
>So base on your views and as well from Boris, Tamar and Robert, I guess i would use the select-sql without the group by (optimize) in this case
>
>Thanks for all the reply. And Naomi, im a (gentle)man... :)
>
>Sonny

The last piece of information was very important for my curiousity. Glad I made the right guess :)