Hello, Winan.
Don't be afraid about table size growing. I know that this is a BIG concern with Access Databases, but it doesn't apply to VFP. If you are carefull with your code, most of the time, VFP gives you amazing performance even with very large tables.
Anyway, if you want to PACK the tables from time to time (as well as rebuild indexes), what we have is a small process running on the server that does it in the middle of the nigth, after it checks that no user is using any table.
As our dear Barbara said, keep an index on deleted(), and if you have any concern about the speed of some process, just turn to th UT!
Good luck!
>Thanks for your quick reply, sounds like I have to pack the tables periodically .the table size is not too large and sometime the records will be deleted and the deleted record is less than 10 %, but I am affraid that the size become too large and the speed will go slow down like what I had when use MS. Access as the Databases, I just want to make packing automation for deleted records.