Oh really sorry, if it hurted you in anyway. Actually when I was replying a neighbour came to my house and in haste i just replied and closed, otherwise.....I am not such a person. Anyway , please dont take it in heart and Thanks a lot for the help.
Regards
'Harsh
>>No sir, The Evaluation condition IF RECNO()%=0 is taking much more time as compared to my original code. I tested it 5 times on around 10000 records and fould that ech time it 30-35 seconds more. that may be perhaps of evaluating the IF condition each time.
>>
>>Than I removed both i.e Wait wind and IF condition , than too I found that there was hardly a 10 sec difference
>>
>>So i dont think that ,that issue is causing a huge delay
>
>Surprised I did not see any 'thank you' in your reply - you might want to learn this
http://www.catb.org/esr/faqs/smart-questions.html>
>Did you test the entire code or just the 3 last lines? The key point for optimization is the Seek() an INDEX on the foreign key of the child table. That'll be equally important with any method including SQL
>
>good luck
Harsh