>>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().
What kind of calculation are you doing? Have you considered using a trigger?
Matt McDonnell
...building a better mousetrap with moldy cheese...