>

>select customer
>scan
>    select sales
>    sum ordertotal for sales.customerid = customer.customerid to
>         nTotalSale
>    replace customer.totalsales with nTotalSale
>endscan
>

>
>The REPLACE statement does not work becuase sales.dbf is EOF(), but why?
>
>
>Just curious....
>
>TIA

How about
*Pseudo code

select customer.customerid as customerid,sum(sales.ordertotal) as ordertotal ;
from ;
customer,sales ;
where ;
sales.customerid = customer.customerid ;
into cursor temp group by 1

select temp
index on customerid tag cusid
select customer
replace customer.totalsales with temp.ordertotal ;
for seek(customer.customerid,'temp','cusid')

suhashegde