You may also use SET KEY TO like this

SET ORDER TO medicinename index tag
SET KEY TO Bill.MedicineName,Bill.MedicineName

>Dear All,
>
>I have Devopled a package for Medical Stores and it works fine as a single system. Now I have conveted to use the same as multi user. It works fine except for the Speed.The Speed is good in the system where the Database (free tables) are stored and Slow in all other systems
>
>I have only database "stock" which holds 40,000 records from Which I have filter to a particular record while doing the Sales. It Takes 15 to 20 Sec to get the item.
>
>Previousl I was using Locate command and then transfer them to bill table once the critiera is met ( it took 40 to 50 Sec).Now I am using Filter condition "SET Filter To Stock.Medicinename=Bill.Medicinename"It Takes 15 to 20 Sec and Is there any other Better method to avoid this time delay
>
>The Exe File is Copied in all the systems and using Set Path to Command I get the Data (Free Tables) from the Server
>
>Thanks For Your Help
>
>With Regards
>
>T.D.Muruganandam