>>In the original code that was written as SELECT-SQL. I re-wrote as dbase command because I want to take buffered data into account as well. But may be for address I don't need to implement dbase. I need to re-think.
>
>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.