>>>How many records do you have per cPointer_fk? Maybe SEEK(m.lcPatients_pk, ...) and LOCATE WHEN...FOR will be faster?
>>
>>Just a few records per patient. Usually one. I did't know we can use LOCATE WHEN Let me re-read docs on LOCATE command.
>
Thanks again for your help. Let me change these places and re-test the speed.
If it's not broken, fix it until it is.
My Blog