>>I am using scan command everytime the form load up, so it calculate every single record. (I want to make sure whatever client enter is being calculate)
>>scan
>> **calculation
>>endscan
>>
>>I want to know is there any other faster command can get the job done faster. Now, everytime client load the form it take 1 minute or so to open up and that's with 16 meg of ram. I can't imagine if the client have less than 16meg of ram, it probably take a while to load.
>
>If you don't care about deleted records, then use RECCOUNT(), otherwise use COUNT ... FOR NOT DELETED() and create index tag for NOT DELETED().

Sorry Edward, I think you misunderstood my question. I am trying to calculate whatever the user have input in a textbox, I could do the calculation in the keypress event, but then the user have to press tab or whatever to execution the calculation. So that why I had use scan command during load up to calculate every record in the table and store the new value in a specific field.